Add User to Existing Role

USE [mydatabase]

GO

ALTER ROLE [db_datareader] ADD MEMBER [myuser]

GO

Generate DDL

Generate DDL for existing Roles...

Roles

db_owner

USE [myDatabase]

GO

SELECT  m.name      AS 'members_name',

        r.name      AS 'roles_name',

        r.type_desc AS 'roles_desc',

        m.type_desc AS 'members_desc'

   FROM sys.database_role_members rm

  INNER JOIN sys.database_principals r ON rm.role_principal_id   = r.principal_id

  INNER JOIN sys.database_principals m ON rm.member_principal_id = m.principal_id

  WHERE r.name = 'db_owner'

  ORDER BY m.name

db_securityadmin

db_accessadmin

db_backupoperator

db_ddladmin

db_datawriter

db_datareader

db_denydatawriter

db_denydatareader

Bibliography