Home Forums SQL Server 2012 SQL 2012 - General Grant Control On Schema verses granting individual permissions on schema? RE: Grant Control On Schema verses granting individual permissions on schema?

  • BOL -

    Object owners can grant permissions on the objects they own. Principals with CONTROL permission on a securable can grant permission on that securable.

    Grantees of CONTROL permission on a schema can grant any permission on any object within the schema.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk