Odd behavior of User_Role_Privs
Posted on 2003-03-18
something i can't explain:
A client had a problem with his menu-security. He had one big power-user FSDDEV who owned all the objects in the application and through public synonyms it were granted to the rest of the company.
He had build in a function that looked at user_role_privs through a cursor like:
SELECT username, granted_role
WHERE granted_role = 'FSD_USERS';
Finally i found out that who ever accessed the function through the public synonyms got to select from this cursor as being the owner FSDDEV and not as being the selecting person (i.e. user avotar). i solved pretty easy (and dirty) by using dba_role_privs.. so no problem there...
the thing i am wondering about is why user_roles_privs behaves this way...