Skip to Content
-1

HANA Security tables

Feb 08 at 09:48 PM

69

avatar image
Former Member

I am trying to find out if I can pull the details around Analytic Privilege's models used and their restrictions by querying the tables from a different tool than going into the studio.

In the structured_privileges table I see the detail of the AP name, restrictions and the values but it doesn't show the details for which model the restriction is setup. Anyone know the tables where I can find this information.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Shashidhar Nagavelli Feb 26 at 06:16 AM
0

Hello,

If you are still looking for finding out the models that are restricted in an Analytical Privilege, please try table _SYS_REPO"."ACTIVE_OBJECTCROSSREF"; give AP details in FROM_ fields and you can get underlying objects in TO_ fields.

In case of Classical dymanic APs, same steps give you the procedure name too (but not the relation between restricted information view & the procedure) and I could not figure out getting procedure information in case of SQL dynamic APs.

Below is the format of SQL:

SELECT "FROM_PACKAGE_ID" "AP Package",
"FROM_OBJECT_NAME" "AP Name",
"FROM_OBJECT_SUFFIX" "AP Suffix",
"TO_PACKAGE_ID" "View Package",
"TO_OBJECT_NAME" "View Name",
"TO_OBJECT_SUFFIX" "View Suffix"

FROM "_SYS_REPO"."ACTIVE_OBJECTCROSSREF"

WHERE "FROM_PACKAGE_ID" = <AP package>
AND "FROM_OBJECT_NAME" = <AP name>
AND "FROM_OBJECT_SUFFIX" = 'analyticprivilege'

T&R,
Shashidhar Nagavelli

Share
10 |10000 characters needed characters left characters exceeded