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