Grant (privilege) Statement
The grant (privilege) statement grants permissions on the database as a whole or on individual tables, views, sequences or procedures. It controls access to database objects, roles, and DBMS resources.
This statement has the following syntax:
grant all [privileges] | privilege {, privilege}
[on [object_type] [schema.]object_name {, [schema.]object_name}]
to public | [auth_type]auth_id{, auth_id};
Note: The grant statement is the ISO/ANSI-compliant method for controlling access to database objects and resources.