The following example grants all authorization IDs the ability to update two specific columns (“col1” and “col3”) in a table called “my_table”:
GRANT UPDATE (col1, col3) ON TABLE my_table TO PUBLIC;
In this case, users without DBA privileges, who possess no other privileges on
my_table
, cannot update any other columns.
The following example grants DBA privileges to an authorization ID called “marketing”:
GRANT DBA TO marketing;
The following example grants to authorization IDs “clive”, “bertrand”, and “nigel” the ability to specify domain “d_char” as a domain argument in a column definition (and also to GRANT USAGE on the domain to other users):
GRANT USAGE ON DOMAIN d_char
TO clive, bertrand, nigel WITH GRANT OPTION;