Contents
Is it possible to grant permissions to an entire schema?
There another account ‘minion’ that you want to have full rights (update/delete/insert/select/alter) on any object (table/view) created under schemas A, B, and C. Is this possible? Or do you have to execute a grant statement each and every time you add a table/ view under these schemas? (seems a bit silly to me).
Can a user deny access to a schema?
You could GRANT schema permissions that are effective for everything existing and everything that will exist in that schema. Further to that, if you want to then deny permissions on a certain object within that schema, you can do. But in your situation, there is no need for you to deny the permission on that user.
Can a grantee of control permission grant any permission?
Grantees of CONTROL permission on a database, such as members of the db_owner fixed database role, can grant any permission on any securable in the database. Grantees of CONTROL permission on a schema can grant any permission on any object within the schema.
How to grant permissions in SQL Server 2014?
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation. Specifies a permission that can be granted on a schema. For a list of the permissions, see the Remarks section later in this topic.. Specifies the schema on which the permission is being granted. The scope qualifier :: is required.
Can a database grant privileges to an object?
That is not possible, the database does not support such grants. You can grant the required privileges on each object individually in the schema. It is better to create a role, grant that role to the other user, and maintain the grants to the role when you create new objects.
How to revoke schema permissions in SQL Server?
Remarks Schema permission Implied by schema permission Implied by database permission ALTER CONTROL ALTER ANY SCHEMA CONTROL CONTROL CONTROL CREATE SEQUENCE ALTER ALTER ANY SCHEMA DELETE CONTROL DELETE