Creates or adds ANSI/ISO-style privileges to an entry of the
Oracle Rdb access privilege set for a database, table, view,
column, module, sequence, or routine. At database creation time,
you specify whether the database protection mechanism will be
ANSI/ISO-style or ACL-style. For more information on creating or
changing the style of privileges associated with a database, see
the CREATE DATABASE statement.
Each entry in an ANSI/ISO-style access privilege set consists
of an identifier and a list of privileges assigned to the
identifier.
o Each identifier specifies a user or PUBLIC access.
o The set of privileges specifies what operations that user can
perform on the database object.
ANSI/ISO-style privileges:
o Grant access to the creator when an object is created. Because
only the creator is granted access to the newly created
object, additional access must be granted explicitly.
o Support only the PUBLIC identifier as a wildcard.
o Support only user identifiers that translate to an OpenVMS
user identification code (UIC), Rdb users, or roles.
For ANSI/ISO-style databases, a user's privileges are a
combination of all privilege sets that apply to that user. The
access privilege set is not order-dependent. The user matches the
entry in the access privilege set; receives whatever privileges
have been granted for the database object; and receives the
privileges defined for PUBLIC. A user without an entry in the
access privilege set receives only the privileges defined for
PUBLIC, which always has an entry in the access privilege set
even if PUBLIC has no access to the database, table, column,
module, or external routine.
To remove privileges from or entirely delete an entry to the
Oracle Rdb access privilege set for a database object, see the
REVOKE_ANSI statement.
Additional Information:
explode
extract