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 |
|