Skip to main content

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.

Hi

 

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

Hi @knepiosko 

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')

Reply


Terms & ConditionsCookie settings