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!
