DB-Type Distinctions
The privilege summary information varies slightly by the type of the target database.
General differences
There are differences by RDBMS type:
- The Users tabs are used for all RDBMS types.
- The Roles tab are used for all RDBMS types, except for MySQL which does not support roles. For DB2 target database, Roles means Groups.
Filtering differences
After selecting a specific user name on the Users tab, or a specific role on the Roles tab, you can filter the displayed privilege information.
For Oracle, DB2, Microsoft SQL Server, and Sybase, the Privilege Type dropdown offers these choices:
- Direct which refers to privileges that have been directly assigned (i.e., not via roles) to the selected user name
- Indirect which refers to privileges that have been assigned via roles to the selected user name
|
MySQL applies the Direct type only. |
For Oracle, the Classification dropdown offers these choices:
- Object Privileges which refers to privileges that pertain to a specific schema or object
- System Privileges which refers to privileges that do not pertain to a specific schema or object
For DB2, the Classification dropdown offers these choices:
- Column Auth which refers to privilege information on certain columns
- DB Authwhich refers to privilege information on certain databases
- Index Auth which refers to privilege information on certain indexes
- Package Auth which refers to privilege information on certain packages
- Schema Auth which refers to privilege information on certain schemas
- Table Auth which refers to privilege information on certain tables
- Tablespace Auth which refers to privilege information on certain tablespaces
For MySQL, the Classification dropdown offers these choices:
- Column Level which refers to privilege information on certain columns. Granting/Revoking grant option is applied for all privileges within the same table only.
- Schema Level which refers to privilege information on certain databases. Granting/Revoking grant option is applied for all privileges.
- Table Level which refers to privilege information on certain tables. Granting/Revoking grant option is applied for all privileges within the same table only.
- User Level which refers to privilege information applied to all databases on the database server. Granting/Revoking grant option is applied for all privileges.
Column and column value differences
The column names and values used by the privilege summary vary by the DB type of your target database. For more information, see the documentation provided by your database vendor for system tables, views, and/or catalogs.