Tuesday, June 24, 2008

Grant select to all objects of a schema to user or group (SQL 2005)

Longer title for this blog than the syntax:

GRANT SELECT ON SCHEMA::[SCHEMA_NAME] TO USER

Then you could go into the properties for the group or user and add other rights, like execute, update, delete.

No comments: