Skip to Content
avatar image
-1
Former Member

HANA Security tables

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 26 at 06:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded