December 5, 2006 at 12:40 pm
I have a SQL Server login aliased as dbo in a database. This account needs to have only a restricted view of our membership table so I have created a view with that subset. What do I need to change in terms of permissions so that the user is still dbo, but has no access to the main membership table directly, but can open the view.
December 5, 2006 at 1:22 pm
Just deny the access to Main Membership table...
Deny select on tablename to username...
MohammedU
Microsoft SQL Server MVP
December 5, 2006 at 7:12 pm
You can do this by adding the user as a member of the db_owner database role then denying him select access to the table as Mohammed Uddin suggests. Just make sure he is not a member of the sysadmin fixed server role. sysadmins cannot be denied access at the database level.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply