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.
| Author |
Topic |
|
nduggan23
Starting Member
42 Posts |
 Posted - 2009-05-25 : 06:51:30
|
| Hi All,Bit of a query. How do i take a database and hide it from all users except dbas, and one db owner? i have a dbas group plus sa and then an login called budget. Database called BudgetDB. is it possible to hide the existance of this database from all other users on the server? so they cant even see it in SSMS? Regards, N. |
|
|
nduggan23
Starting Member
42 Posts |
Posted - 2009-05-26 : 05:23:21
|
| anyone have any ideas? or maybe a pointer in the right direction? |
 |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-05-26 : 09:47:09
|
| Breifly stated, you would setup various sql logins, one for each user or group of users, then assign the sql logins access rights to only those data bases they are authorized to access.Talk sense to a fool and he calls you foolish. |
|
|
|
nduggan23
Starting Member
42 Posts |
Posted - 2009-05-26 : 09:57:21
|
| i know i can setup logins to access each database. never a question about that. what i dont want to happen is when you create a login it still has the ability to view (not access) all databases that are created in SSMS. so i want to hide the database from even this view if possible. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-05-26 : 10:21:36
|
| Are your business users logging on to SSMS?Talk sense to a fool and he calls you foolish. |
|
|
|
nduggan23
Starting Member
42 Posts |
Posted - 2009-05-26 : 10:39:49
|
| No. its a security requirement that need to be put in place to lock out all possible access to a certain database except to the dba group and the single owner/user of the system. They dont want it visible or remotely accessible to anyone at any level. over engineered security if you ask me but something ive to try get working. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-05-26 : 10:45:14
|
| I'm not understanding how your business users are accessing your Sql Servers and viewing/seeing databases they are not authorized to see? Your DBA's should be the only employees that have access to SSMS.Access to databases can easily be restricted by using sql logins.Talk sense to a fool and he calls you foolish. |
|
|
|
|
|
|
Hiding Databases from a login