GRANT Statement

The GRANT statement grants access privileges for a SQL/MX table, view, MV, schema, sequence generator, or stored procedure to specified users.

You can also grant the authorization to execute:

  • DDL and utility operations at the schema level using DDL privileges.

  • DML operations at the schema level and such authorization applies for individual objects within the schema. 

GRANT {privilege [,privilege]... | { ALL | ALL_DML | ALL_DDL } [PRIVILEGES]}
    ON target
    TO grantee [,grantee ]...
    [WITH GRANT OPTION]
    [BY authid-grantor] 

grantee is:
   authid    | 
   PUBLIC    |
   DB_PUBLIC |
   PRIVILEGE GROUP pg-name 

privilege is:
     SELECT                          
   | DELETE                          
   | INSERT                          
   | UPDATE [(column [,column]...)]  
   | REFERENCES [(column [,column]...)]
   | USAGE
   | EXECUTE
   | CREATE
   | ALTER
   | DROP 

target is:
   { object-specification }
   { schema-specification }

object-specification is:
[ TABLE | SEQUENCE | PROCEDURE ] 
object-name

schema-specification is:
   { SCHEMA schema-name }