Object permissions regulate the use of certain statements on certain database objects. They are granted and revoked by the owner of the object. Object permissions apply to the following statements and objects:
| Statement | Object |
|---|---|
| SELECT | Table, view, columns |
| UPDATE | Table, view, columns |
| INSERT | Table, view |
| DELETE | Table, view |
| REFERENCE | Table |
| EXECUTE | Stored procedure |
With SQL Server 6.0, REFERENCE permission provides for ANSI compatability of referential constraints. It allows foreign key references to a given table without having SELECT permissions on that table. This permission is checked when a table is created, and the user creating the table must have either SELECT or REFERENCE permission on any referenced tables. (Creating a reference to a table implies that the referenced table has permissions to verify any references back to the table in the CREATE statement.)
To grant or revoke object permissions, use SQL Enterprise Manager or the GRANT and REVOKE statements. For information about managing permissions with SQL Enterprise Manager, see Chapter 9, Managing Security. For information about the GRANT and REVOKE statements, see the Microsoft SQL Server Transact-SQL Reference.