SQLTeam.com | Weblogs | Forums

Grant User to view Database

Hi,

Have create two new SQL User ("UserA", "UserB").
And have denied the above user to not view any Databases
DENY VIEW ANY DATABASE TO UserA/UserB

Now I required to grant one Database access to above two user. LEt it be any role to the user. But the Database need to be viewed for both the user.
While trying below command user assigned as dbOwner for the DB (But restricted with one user)
ALTER AUTHORIZATION ON DATABASE::DBName to UserA (Works)
ALTER AUTHORIZATION ON DATABASE::DBName to UserB (Works but above is deleted)

Can any one help me to figure out this..