SQL$HELP72.HLB  —  SHOW  Arguments  ON syntax options
    List of syntax options:

       ON TABLES
       ON VIEWS
       ON COLUMNS
       ON FUNCTIONS
       ON PROCEDURES
       ON MODULES
       ON SEQUENCES sequence-name

    Specifies the object for which you want to display access
    privilege set information with the SHOW PRIVILEGES or SHOW
    PROTECTION statement. You can specify a list of names, but
    you must specify at least one item to display a list. You must
    qualify a column name with at least the associated table name.

    In an ANSI/ISO-style database, the SHOW PROTECTION statement
    displays which privileges have the option of being granted to
    other users and which privileges are without the grant option.
    See the SHOW USERS WITH and SHOW USERS GRANTING statements in
    this section for more information about displaying privileges
    granted directly or indirectly to other users.
Close Help