SQL$HELP72.HLB  —  SHOW  Arguments  PRIVILEGES
    Syntax options:

    PRIVILEGES | PROTECTION

    Displays current user identifier and available access rights for
    the specified object.

    o  The SHOW PRIVILEGES statement displays the current user
       identifier and available access rights to the specified
       databases, tables, views, columns, external functions,
       external procedures, modules, or sequences.

       This statement displays not only the privileges that are
       explicitly granted to the user, but also any privileges
       that the user inherits from database access or the operating
       system.

       In a client/server environment, the entry shows the identifier
       of the client. For example, if a user attaches to a remote
       database using the USER and USING clauses, SQL shows the
       privileges for the user specified in those clauses.

       In an environment that is not client/server, such as when you
       attach to a local database, SQL shows not only the privileges
       of the database user, but of the logged-on process. For
       example, if user heleng, with the OpenVMS privilege BYPASS,
       uses the USER and USING clauses to attach to the database as
       user rhonda, SQL shows that user rhonda has the privileges
       inherited from the logged-on process heleng, as well as
       privileges for user rhonda.

    o  The SHOW PROTECTION statement displays all of the entries in
       the access privilege set for the specified databases, tables,
       views, columns, external functions, external procedures,
       modules, or sequences.
Close Help