Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2011
    Posts
    78

    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 10:32.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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.

  3. #3
    Join Date
    Jul 2011
    Posts
    78
    Yes, permission to have full control of the database.
    Is there a place to add users to have that type of permission?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    So your user needs to be able to do all of the things I put in my post above?

  5. #5
    Join Date
    Jul 2011
    Posts
    78
    Yes, I granting the full control permission to my supervisor. Where is the place to do that? Thank you.

  6. #6
    Join Date
    Jul 2011
    Posts
    78
    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.

  7. #7
    Join Date
    Jul 2011
    Posts
    78
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •