Granting Permissions for an Object

Use the GRANT statement to assign security permissions for an object in a database to an existing user or group account. The procedure in Hands-On 22-9 grants the SELECT, DELETE, INSERT, and UPDATE permissions on all tables to the Mozart group.

The GRANT statement requires the following:

■ A list of privileges to be granted

The keyword ON followed by the name of a table, a non-table object, or an object container (e.g., Tables, Forms, Reports, Modules, Scripts)

■ The keyword TO followed by the user or group name

GRANT listOfPermissions ON tableName | objectName | containerName TO accountName

Please note that in addition to tables, the Tables container contains queries, views, and procedures, and the Scripts container includes macros.

0 0

Post a comment