Skip to content
«
»
 

Add User to Role

Posted by 
on  July 25 2009

To add a user to a role, you must use the stored procedure sp_addrolemember.

First you must select the database that contains the user and the role.

USE YourDatabaseHere
GO
EXEC sp_addrolemember 'db_datareader', 'JohnJacobs'
EXEC sp_addrolemember 'db_datawriter', 'JohnJacobs'
EXEC sp_addrolemember 'db_accessadmin', 'JohnJacobs'
EXEC sp_addrolemember 'db_backupoperator', 'JohnJacobs'
EXEC sp_addrolemember 'db_ddladmin', 'JohnJacobs'
EXEC sp_addrolemember 'db_denydatareader', 'JohnJacobs'
EXEC sp_addrolemember 'db_denydatawriter', 'JohnJacobs'
EXEC sp_addrolemember 'db_owner', 'JohnJacobs'
EXEC sp_addrolemember 'db_securityadmin', 'JohnJacobs'

The example above shows all predefined roles in a database.



Popular search terms:
Filed under Security
Comment (RSS)  |  Trackback  |  Permalink

6 Comments

  1. Ibran Siagian says:
    April 15, 2012 at 8:47 pm

    Thanks for the articles.

    Reply to this comment
  2. Creating Roles and assigning Permission in SQL Server and Oracle « Java Development says:
    October 9, 2011 at 12:15 am

    [...] Source 2: SQL Server Planer [...]

    Reply to this comment
  3. anwar says:
    August 2, 2011 at 3:36 pm

    very helpful. thank you.

    Reply to this comment
  4. James says:
    August 1, 2011 at 8:55 am

    Just an editing point. You were going to cover adding a user with the interface.

    Reply to this comment
  5. Jasbir says:
    December 6, 2010 at 2:20 pm

    Thanks.
    That was most helpful

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»