I have a MSSQL 2005 server set up and running. I would like to be able to have the following setup:
database_one
with user_one
as db_owner
and
database_two
with user_two
as db_owner
The tricky part (for me at least) is that I would like database_one
to be hidden from user_two
and database_two
to be hidden from user_one
.
So far, I've found the VIEW ANY DATABASE
permission. Playing around with this it seems like no matter how I set up the more specific permissions for a user, the VIEW ANY DATABASE
permission takes precedence.
If I run DENY VIEW ANY DATABASE TO user_one
, connecting as user_one will show only the master
and tempdb
system databases, even if user_one is set up as db_owner of database_one.
Is there a way to set up the permissions to do what I want?