Create a role that gives a user permissions on a specific schema.

Creates a role named 'SpecificSchemaSuperPowers' That gives specific permissions (ALTER, DELETE, EXECUTE, INSERT, REFERENCES, SELECT, UPDATE, VIEW DEFINITION) on a specific schema 'SpecificSchema' ( And adds a particular user (AD\BambrickL) to that role

CREATE ROLE SpecificSchemaSuperPowers AUTHORIZATION dbo;

GRANT ALTER, DELETE, EXECUTE, INSERT, REFERENCES, SELECT,
          UPDATE, VIEW DEFINITION ON SCHEMA::SpecificSchema TO SpecificSchemaSuperPowers;

EXEC sp_addrolemember 'SpecificSchemaSuperPowers', 'AD\BambrickL';

results matching ""

    No results matching ""