Post reply

Minimum Permission to create a database snapshot

  • June 14, 2013 at 9:24 am

    #278581

    Hi Experts,

    I know the permission required to create a DB snapshot is same as creating a database. Can anyone please let me know how to give minimum permission for creating the same other than dbcreator.

    Thanks in Advance

  • June 14, 2013 at 9:33 am

    #1624176

    From Books online:

    Permissions

    Requires CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission.

    Since you changed the question...

    You GRANT any of the permissions listed above, or give the dbcreator role, which does just about the same thing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 14, 2013 at 10:31 am

    #1624198

    Thanks Gail..

    I gave dbcreator server role and ddladmin db role so that the user can create snapshot of only that particular existing userdb.

  • June 14, 2013 at 11:04 am

    #1624217

    Members of the dbcreator fixed server role can create, alter, drop, and restore any database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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