I'm hoping someone will be able to answer my simple question!
Previously, I've run the below script to give one user access to their db in SQL management studio but nothing else.
use [someDB] -- use the real db name
sp_changedbowner 'theUser' -- use the new username
4. Next, deny the new user "public" access to ALL databases:
deny VIEW any DATABASE to theUser
However I now need to add an additional user with view on permissions to the database and can't figure out how to do it. I'm sure it's simple but my SQL knowledge is at a low level.
View Complete Post