Specific User Category Privileges
The following table indicates the specific privileges granted to each user category.
|
User Category |
Database Object Type |
Privileges Granted |
|
Normal |
QCD tables |
|
|
X views |
SELECT |
|
|
X macros |
EXEC |
|
|
Non-X views |
none |
|
|
Non-X macros |
none |
|
|
Power |
QCD tables |
|
|
X views |
SELECT |
|
|
X macros |
EXEC |
|
|
Non-X views |
SELECT |
|
|
Non-X macros |
EXEC (excluding DELETE plan and workload macros) |
|
|
Administrator |
QCD tables |
|
|
X views X views use the value for UDB_Key in the Query table to restrict access to request plans to the user who captures them, while the Non‑X views do not restrict that access. |
|
|
|
X macros |
|
|
|
Non-X views |
|
|
|
Non-X macros |
|