Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Prevent users from seeing DBs?

Author  Topic 

Goudinov
Starting Member

14 Posts

Posted - 2002-11-14 : 10:35:15
Is it possible to create a SQL 2000 user in a way so that when someone registers the DB in Enterprise Manager they don't even see databases for which they have no access. Basically I want to hide these databases from their view.

Currently they can see the databases, but they can't get into them of course, but I don't even want the users to know that these databases exist.

thanks,

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2002-11-14 : 12:03:27
I don't believe there is a way to do this. I know it's been requested from Microsoft.

Go to Top of Page

Goudinov
Starting Member

14 Posts

Posted - 2002-11-14 : 23:20:18
Thanks for the reply. I found elsewhere that you are correct. Kind of annoying, but I sort of understand why it's that way. Oh well.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-11-15 : 07:27:39
quote:

Basically I want to hide these databases from their view



Poke their eyes out

Damian
Go to Top of Page

Goudinov
Starting Member

14 Posts

Posted - 2002-11-15 : 09:14:22
quote:
Poke their eyes out

Damian

Oh that's just GREAT! Now I have to put in a requisition for hot coals and a fire poker. Purchasing is not going to like this...

Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-11-15 : 09:25:58
Well, as long as you're ordering them, you might as well include a fireplace...should make your cubicle nice and cozy; be the envy of your co-workers!

Go to Top of Page

Goudinov
Starting Member

14 Posts

Posted - 2002-11-15 : 09:31:02
heh who not? I already have the most amount of computers as well as full-spectrum lighting..

/me heads over to the developer forum...

Go to Top of Page
   

- Advertisement -