+10
Hi all,
As i said in the title i am looking for a way to find this in db level.
For example which users have permission to see frmProductStructure?
I am finding this as manuel in solution manager/Permission Sets etc. But maybe there is a easiest way in db level with a simple query.
Best Regards.
Best answer by knepiosko
View originalHi
Try this:
select *
from pres_object_grant_tab
where role in
(select granted_role from dba_ROLE_PRIVS where grantee = 'USERNAME');
po_id is also window name
+10
Hi
Thats it! Thank you so much.
I configured your main logic like below and this is the pure solution for this case.
Best regards.
SELECT * FROM dba_ROLE_PRIVS WHERE granted_role IN (SELECT ROLE FROM pres_object_grant_tab WHERE po_id = 'frmProductStructure')
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
