Elephant Wishes (SQL Server and Data Ramblings)
I wish I could remember everything...
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.