Skip to main content
Question

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

  • October 27, 2025
  • 4 replies
  • 68 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?

 

 

4 replies

Forum|alt.badge.img+17
  • Superhero (Partner)
  • October 27, 2025

HI ​@arebbeadle 

 

Try these tables: Security_Sys_Tab and Security_Sys_Privs_Tab


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • October 28, 2025

@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)
  • November 21, 2025

select * From security_sys_tab

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


Forum|alt.badge.img+12
  • Hero (Customer)
  • November 22, 2025

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__