To display privileges on a database resource, you must hold DBADMIN privilege on the current dictionary, SYSADMIN privilege, or the privilege listed in this table:
|
Resource type |
Privilege to display privileges |
|---|---|
|
Access Module |
DISPLAY (WITH GRANT OPTION) on the access module |
|
Area |
DISPLAY (WITH GRANT OPTION) on the segment containing the area |
|
Database |
DISPLAY (WITH GRANT OPTION) on the database identified as a DB resource |
|
Database name table |
DISPLAY (WITH GRANT OPTION) on the database name table |
|
DMCL |
DISPLAY (WITH GRANT OPTION) on the DMCL |
|
Non-SQL-defined schema |
DISPLAY (WITH GRANT OPTION) on the non-SQL-defined schema |
|
SQL-defined schema |
DISPLAY (WITH GRANT OPTION) on the schema |
|
Table |
DISPLAY (WITH GRANT OPTION) on the table |
|
Copyright © 2014 CA.
All rights reserved.
|
|