SQL$HELP_OLD72.HLB  —  GRANT_ANSI
    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
Environment Format Arguments Examples
Close Help