August 1, 2012 at 5:21 am
Hi,
I have 5 tables in the test database
namelist
agelist
gender
locationlist
timezone
i have given dbowner rights to harry login , has a sysadmin rights in server roles, user mapped for test database, database roll membership is public.
Here i need to give rights for the namelist, agelist table only...how to do?
August 1, 2012 at 5:41 am
If the login is part of sysadmin server role, then he can do everything on the server and you can not limit his actions. You'll have to to remove him from sysadmin server role, then also remove him from db_owners role. After that grant him the needed select/update/insert/delete permissions.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply