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 |
|
michaelro
Starting Member
4 Posts |
 Posted - 2009-02-19 : 07:29:47
|
| I am creating several logins for different databases that sit on the same server.Each user will have access to 1 database and none of the othersAfter creating 1 login, I tested it to see if the denyreader works - However, I can still physically see the databases themselves - I can't access any of the database - is there a way of hiding the database completely? |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-19 : 07:41:08
|
| why not remove the access to the db completely at login level. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 12:15:57
|
| They will see the databasename but won't be able to access it.Error message for them will be:Databasename is unaccessible |
|
|
|
|
|
|
Hide Database