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