How do I limit the list of databases seen in SQL 2005 to only those a user has permissions to? For example, in STM, when a user logs in, they see all databases. How does one limit this?
Thanks,
I'm doing some analysis of storage in an environment and I'm reviewing some data for a few Netapp filers. I was hoping to gain some understanding from the group here on a few data points that I don't really get. I've personally not worked with Netapp devices before so any help here would be...
I am running a discovery tool against a system that has the Checkpoint SecuRemote VPN client installed. This client has policies that I assume are pushed down to it from a master server.
When i run our discovery against this system, the first couple of packets to port 135 will be accepted...
DBD::mysql::st fetchrow_array failed: fetch() without execute()
This is the error I'm getting on a simple script. I don't understand what I'm doing wrong. Can someone please help me understand what I'm doing wrong?
#!/usr/bin/perl
use strict;
use DBI;
# Connect to the database.
my...
Hi all. I recently installed a service-policy on my PIX to police inbound http responses from the Internet. Although I got it to work, in order to do so, I had to apply it to the inside interface of my PIX and set the source port to http? This didn't make any sense to me.
access-list...
I have a simple script that I need to return the timestamp of files as YYYY-MM-DD. Im using HTTP::Date but it's returning more than I need. Is there a way to further format the date easily?
#!/usr/bin/perl -w
use File::stat;
use Time::localtime;
use Time::Zone;
use HTTP::Date qw(parse_date...
I'm trying to understand why i get "table or view does not exist" when i execute a select statement against a table in a local production database versus getting the object returned in a development database. The only execption is when I append "USERS." onto the tablename when making the query...
First and foremost, I'm a novice.
Just want to make that clear because some of what I may ask may sound stupid but I'm trying to understand here so any help would be appreciated.
I'm working on extending a function in MailScanner (http://www.mailscanner.info) that will allow me to implement...
Hi. I'm writing a series of sub-functions that expand to provides some qos capabilities to MailScanner. I'm just a beginner, but I think I'm almost there.
my $PriorityDir = '/etc/MailScanner/qos';
my(%PriorityList);
use FileHandle;
sub InitMultipleQueueDir {...
I am have an issue. (I know, get in line :) )
I have a user that with a Cisco 7960G behind a 3002 hardware vpn client. We are having one-way voice quality issues when the user calls anyone outside of the company, IE his phone talks to the gateways not another 7960. Packet captures show high...
Hi. I'm trying to use Oracle Management Server to give people tiered access to Oracle databases scattered throughout my orgainzation. In my testing - I find that I'm having some issues getting the node level permissions correct. For example, I have a test user who is trying to export and import...
Hi. I'm researching our capability for TSPITR and I got some docs, books and etc. In checking to see if we have the ability, I got some information from querying the ts_pitr_check table that I don't know how to translate. Can someone help me understand what the issue is. According to my...
Hi. I'm trying to work around a problem and I was hoping to get some input from folks who are a bit more knowledgeable then me in this regard.
I have an application that some people in my company access via WebVPN, a service on the Cisco VPN concentrators.
A portion of this application uses js...
Hi. We are getting a cisco phone system. The call managers and vm servers will need to support a remote site connected to our main campus via 2 T-1 that will be used to transport packet voice and an 8MB link for other data. The call mgrs will be located on the main campus. The plan is to define...
I'm doing some test restores of my primary sql 2000 box onto a test server that does not share the same drive letters and directory structure. Restoring the non-system databases goes fine without a hitch. However when I restore the master database, SQL now looks for the non-system databases in...
I'm trying to delete a large number of rows from a table, but a bit after the operation begins, the Tlogs fills up and the operation stops. I've ran into this before and found a way to delete them using a Loop statement I think. I can't recall the information however. Can anyone help me out?
I'm putting together a backup strategy for a database using RMAN. It's more involved than what we normally do which is daily full backups of the all data files, archived logs, control files and parameter files. I'm trying to determine what are the disadvantages to just relying upon log files...
Hi. I'm just doing some DR testing and I'm trying to restore the database from a backup piece in an alternate location. Much like you would restore a control file or the spile from an alternate location. Rman does not seem to allow that. How do I tell it that my autobackup is not in the same...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.