Post reply

Securityadmin server role permissions

  • February 28, 2008 at 9:08 am

    #783298

    You add them to the security admin group in the database. That should be fine.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 28, 2008 at 9:19 am

    #783310

    In BOL it says:

    Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level permissions. Additionally, they can reset passwords for SQL Server logins.

    Why, then, do we have to grant the login the db_securityadmin role in each database?

  • February 29, 2008 at 9:22 am

    #783892

    Is this sorted out or still having issues?

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply