var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Granting permission to other users in SQL 2008???
Anyone know how to set up a role to grant full permission of the database to others in SQL 2008?
Please let me know, thank you.
Last edited by Mangolili; 07-28-11 at
What do you mean by 'full permission"? Ability to create/drop objects? Ability to read any table/execute any procedure? Backup the database? Restore the database? All of these are different permissions and not surprisingly different functions.
Yes, permission to have full control of the database.
Is there a place to add users to have that type of permission?
So your user needs to be able to do
all of the things I put in my post above?
Yes, I granting the full control permission to my supervisor. Where is the place to do that? Thank you.
Is there a way to grant access to the database without writing queries? I have been searching for ways to do it, a lot of results showed queries to grant rights.
I found the answer to my own question, just want to post the link here in case anyone else wants to know:
Granting Access to a SQL Server Database