ON SCHEMA :: schema_name

Hi,

Could you explain what a scope qualifier is (the two "::" colons) and what it is used for?

Thanks.It is used to scope permissions to a particular object: I.e. GRANT ALTER ON SCHEMA::mySchema to nielsb gives the user nielsb rights to create tables etc in that schema. This is not limited to only schemas, but are used for almost all database objects.
Niels|||Thank you Niels!|||

SQL 2K5

This :: syntax is covered in the BOL topic for the GRANT, DENY, and REVOKE statements.

To elaborate on Niels's post, you need ALTER permission on a schema and CREATE TABLE permission to create a table.

Also - note that ALTER permission on a container like a schema or database gives the grantee the ability to DROP contained objects as well. So if I give you ALTER permission on schema S, then you can DROP tables (or procs or views or ...) in S.

sql