November 30, 2012 at 9:17 pm
hi
i create a user in sql server 2008,i login with it .(it has sysadmin and public server role)
with this user i try to grant a permission to the current server.so i cheched the check boxes that i want and click "ok". now i come back to server properties page / permissions ,for certitude ,but all the permission that i granted now is unchecked.please help me about it.
November 30, 2012 at 11:04 pm
pooya1072 (11/30/2012)
hii create a user in sql server 2008,i login with it .(it has sysadmin and public server role)
with this user i try to grant a permission to the current server.so i cheched the check boxes that i want and click "ok". now i come back to server properties page / permissions ,for certitude ,but all the permission that i granted now is unchecked.please help me about it.
You do know that by virtue of making this login sysadmin, it already has all the rights and privledges without having to explicitly granting them. Sysadmin has all rights on the instance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply