none
Provisioning Permissions RRS feed

  • Question

  • I'm trying to create a database role in SQL Server 2012 that will allow a user who is a member of that role to provision the database for sync. As dbo the provisioning works just fine but I want a role to be defined with just the minimum permissions.

    I am following the guide offered here:

    http://msdn.microsoft.com/en-us/library/ee845032(v=sql.100).aspx

    So far I have:

    • Created a new role 'Administrator' that owns no schemas.
    • Granted CREATE PROCEDURE and CREATE TABLE permissions on the entire database.
    • I don't want to explicitly refer to any particular user tables at this point and all the tables I have are in the 'dbo' schema so I grant SELECT and ALTER permissions for the 'dbo' Schema listed under the Schema Type in Securables.
    • Then the guide says that I need to grant "AUTHORIZATION permission on the schema for all provision tracking tables". I don't understand this. What is the 'AUTHORIZATION permission'? And because at this point the database isn't provisioned, surely the tracking tables don't exist, yet.
    Can anyone explain this last permission or intention, please?

    Thanks!



    • Edited by Jυstin Thursday, May 15, 2014 11:44 AM
    Thursday, May 15, 2014 11:44 AM