Security Fiori important Tables , T-codes and Queries

  Important T-codes:

/UI2/FLPD_CUST - Launchpad Designer (can add/remove catalogue/group/Tile/TM  -Browser view)

/UI2/FLPCM_CUST - FLP content manager (ADD/Remove Tiles from catalogue) (maintain catalogue present in role)  (SAP GUI view)

/UI2/FLPCAT -Fiori catalogue maintenance

/UI2/FLPCA- Launchpad content aggregator (roles vs catalogue)

SCTS_HTA - Transport HANA Studio role changes (add security package and execute)

Important Tables :

USOBHASH - Table Service name(Field: Object name) vs HASH value(Field: Name)

AGR_BUFFI - Catalogue vs Role, Group vs Role , Hash Value Vs Role

HANADB SQL Queries -

1) To get details of error GUID code

call sys.get_insufficient_privilege_error_details('GUID' , ? )

2) AGR_USERS -

select grantee, role_name from granted_roles;

select * from granted_roles;

select * from granted_roles where role_name like '%SECURITY_Y%'

select grantee, role_name from granted_roles where  grantee in ('Gitesh') and role_name <> 'PUBLIC';

3)USR02

Select * from users;

4)To find Roles having access to Root package/particular package-

Select Grantee from Granted_privileges where OBJECT_NAME= '.REPO_PACKAGE_ROOT'