2. Statements : OpenROAD SQL Statements : Grant (privilege) Statement
 
Share this page                  
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.