Schema Browser | Users | Username
Click any of the "Role Grants", "System Privileges", or "Object Grants" tabs on the right side, results in the following error:
"The SELECT privilege is required on DBA_ROLE_PRIVS" followed by
Oracle error "ORA-00923: FROM keyword not found where expected"
If the logged on user does not have privileges to access DBA_SYS_PRIVS or DBA_ROLE_PRIVS, then the SQL statement, generated by Toad to query for these permissions, is incorrect.
This error may also occur if public synonyms for DBA views have been removed, even if user does have privileges to query SYS.DBA_SYS_PRIVS or SYS.DBA_ROLE_PRIVS
WORKAROUND
If user does have privileges to access SYS.DBA_SYS_PRIVS or SYS.DBA_ROLE_PRIVS, but public synonyms have been removed, create a private synonym DBA_SYS_PRIVS and DBA_ROLE_PRIVS for that user.
If public synonyms do exist for these views (the Oracle default), then permission should be given to the user to query SYS.DBA_SYS_PRIVS or SYS.DBA_ROLE_PRIVS
STATUS
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center