I've encountered a problem with how the Roles folder in the Object Browser is selecting its data. When the user logs into the database using proxy syntax, the Object Browser does not populate the Roles folder.
I logged in to PSD 12.0.7.1837 in DebugSQL mode and looked at the results.
00:00:19.315 TOracleQuery PLSQLDevForm.RoleQuery Start Query.Execute
SQL = select * from /*NOALL*/ sys.dba_roles
order by role
00:00:19.338 TOracleQuery PLSQLDevForm.RoleQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.015
00:00:19.344 TOracleQuery PLSQLDevForm.UserGrantedRolesQuery Start Query.Execute
SQL = select granted_role, admin_option, default_role
from sys.user_role_privs
where username = :grantee
order by granted_role
:GRANTEE = ACTUALUSER[ADMINUSER]
00:00:19.423 TOracleQuery PLSQLDevForm.UserGrantedRolesQuery End (0 records processed)
Duration = 0.078
When it queries USER_ROLE_PRIVS, it should be looking for GRANTEE = ADMINUSER.
Thanks.
I logged in to PSD 12.0.7.1837 in DebugSQL mode and looked at the results.
00:00:19.315 TOracleQuery PLSQLDevForm.RoleQuery Start Query.Execute
SQL = select * from /*NOALL*/ sys.dba_roles
order by role
00:00:19.338 TOracleQuery PLSQLDevForm.RoleQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.015
00:00:19.344 TOracleQuery PLSQLDevForm.UserGrantedRolesQuery Start Query.Execute
SQL = select granted_role, admin_option, default_role
from sys.user_role_privs
where username = :grantee
order by granted_role
:GRANTEE = ACTUALUSER[ADMINUSER]
00:00:19.423 TOracleQuery PLSQLDevForm.UserGrantedRolesQuery End (0 records processed)
Duration = 0.078
When it queries USER_ROLE_PRIVS, it should be looking for GRANTEE = ADMINUSER.
Thanks.
