Skip to main content
Solved

Are Permission Sets data (Method Objects) stored in a table?

  • Oct 27, 2025 7:23 PM UTC
  • 4 replies
  • 167 views

arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

Are Permission Sets data (Method Objects) stored in a table? I need to know where I can find this data? This shows a visual chech box of object method that are granted to a permission set. Where is this data stored?

 

 

Best answer by SimonTestard

To clarify ​@knepiosko ‘s point:

 

Security_Sys_Privs_Tab will contain the packages that are Granted for Execution

Security_Sys_Tab will contain the Package Methods that are REVOKED from permissions, meaning that the Role cannot execute that specific method.

 

So:

 

If you see Customer_Agreement_Api in Security_Sys_Privs_Tab, but you do NOT see its method Modify__ in Security_Sys_Tab, this means the Role CAN execute Customer_Agreement_Api.Modify__

 

View original

4 replies

Forum|alt.badge.img+17
  • Superhero (Partner)
  • Oct 27, 2025 9:45 PM UTC

HI ​@arebbeadle 

 

Try these tables: Security_Sys_Tab and Security_Sys_Privs_Tab


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • Oct 28, 2025 12:25 PM UTC

​@knepiosko  thank you for your input but this does not provide everything I need., I need to know which objects have been granted permission like ‘Modify__, Lock__, New__, etc..’. Is this possible?

Sample:

CUSTOMER_AGREEMENT_API.MODIFY__

 

 

 


Forum|alt.badge.img+17
  • Superhero (Partner)
  • Nov 21, 2025 6:00 PM UTC

select * From security_sys_tab

If procedure or function does not exits means it is granted.


Forum|alt.badge.img+12
  • Hero (Customer)
  • Answer
  • Nov 22, 2025 8:49 AM UTC

To clarify ​@knepiosko ‘s point:

 

Security_Sys_Privs_Tab will contain the packages that are Granted for Execution

Security_Sys_Tab will contain the Package Methods that are REVOKED from permissions, meaning that the Role cannot execute that specific method.

 

So:

 

If you see Customer_Agreement_Api in Security_Sys_Privs_Tab, but you do NOT see its method Modify__ in Security_Sys_Tab, this means the Role CAN execute Customer_Agreement_Api.Modify__