System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Grant (privilege) Statement
Was this helpful?
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.
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.
Last modified date: 12/20/2023