How to get all field details of ACL Table List in Excel including Roles, Condition and Scripts?

VIKAS45
Tera Guru

‎03-06-2023 02:15 AM

How to get all field details of ACL Table List in Excel including Roles, Condition and Scripts?

0 Helpfuls
  • 903 Views
3 REPLIES 3

SatyakiBose
Mega Sage

‎03-06-2023 03:30 AM

Hello @VIKAS45 

You can export the below set of columns as an excel using the export functionality in the ACL (sys_security_acl) table.

SatyakiBose_0-1678102138911.png

 

SatyakiBose_1-1678102166477.png

However, you cannot export the role defined in the ACL in the same excel because that is a separate table - sys_security_acl_role

 

0 Helpfuls

VIKAS45
Tera Guru
In response to SatyakiBose

‎03-06-2023 03:55 AM

How Can I export Role related to ACL alongwith Condition and Script

0 Helpfuls

SatyakiBose
Mega Sage
In response to VIKAS45

‎03-06-2023 03:57 AM

Hi @VIKAS45 

You cannot because both of them are different table.

So first you need to export the table - sys_security_acl & then export the table sys_security_acl_role.

Then when you import this to the target instance, it will map it to the corresponding ACL.

 

0 Helpfuls