Home Forums SQL Server 2008 Security (SS2K8) reader role for user define db role brain freeze RE: reader role for user define db role brain freeze

  • June 13, 2014 at 12:31 pm

    #1721629

    EXEC sp_addrolemember 'db_datareader', 'DOMAIN\HELPDESKGROUP'

    GRANT UPDATE, DELETE ON onespecifictable TO [DOMAIN\HELPDESKGROUP]

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]