The following error occurs selecting Script tab of a user under Users tab of Schema Browser:
"Cannot Access Users Script error ORA-00979"
Error occurs executing the following background query:
Select * from dba_rsrc_consumer_group_privs
where 1=1 and grantee = :OneObjName
The selected user account is assigned to certain resource group. Therefore, Toad will run the above query in the background to gather the information on its assigned resource groups grants.
This error is caused by an existing Oracle defect, Bug 5059447 for Oracle 10.2.0.4 databases. Refer to Oracle Metalink for more information on this defect.
The below option can be modified to bypass background query when viewing the Script tab of Users tab:
1. Select a user account in Schema Browser that does not result in the error message
2. Under the Script tab, select "View/edit script options" icon on its toolbar
3. In this window, select Users tab and uncheck "System Privileges" and hit OK
Note: With the above option uncheck, system grant commands for this user such as the resource group grants will not be included in the script.
