Creates or adds privileges to an entry to the Oracle Rdb access
privilege set, called the access control list (ACL), for a
database, table, view, column, module, or external routine.
Each entry in an ACL consists of an identifier and a list of
privileges assigned to the identifier:
o Each identifier specifies a user or a set of users.
o The list of privileges specifies which operations that user or
user group can perform on the database, table, view, column,
module, or external routine.
When a user tries to perform an operation on a database, SQL
reads the associated ACL from top to bottom, comparing the
identifier of the user with each entry. As soon as SQL finds
the first match, it grants the rights listed in that entry and
stops the search. All identifiers that do not match a previous
entry "fall through" to the entry [*,*] (equivalent to the SQL
keyword PUBLIC). If no entry has the identifier [*,*], then users
with unmatched identifiers are denied all access to the database,
table, view, column, module, or external routine.
For this reason, both the entries and their order in the list are
important.
Under the Oracle Rdb default protection scheme, when you create
a new database, table, view, module, or external routine, you
get all access rights to that object, including DBCTRL. All
other users of that object are given no access rights to it.
For any tables or views created under the Oracle Rdb default
protection scheme, the creator of the table or view receives all
the access rights to the object, including DBCTRL, and all other
users receive no access rights to the object.
The DBCTRL access right enables an object's creator to grant
DBCTRL to other users. See the Oracle Rdb SQL Reference Manual
for information on how you can tailor the default protection for
any new tables that you create within a database.
To remove privileges from or entirely delete an entry to the
Oracle Rdb access privilege set for a database, table, column,
module, or external routine, see the REVOKE.
Additional Information:
explode
extract