Data Control Language Enhancements

Data Control Language (DCL) refers to Transact-SQL statements that permit access to database objects. SQL Server 6.0 has enhanced object permissions.


Feature area
Related DCL statements and Transact-SQL Reference topics
Object permissions GRANT and REVOKE statements

When FOREIGN KEY constraints are defined, REFERENCES or SELECT permission must be granted on the referenced table. For details, see the GRANT and REVOKE statements.