Friday, August 12, 2011

Exporting Security out of Hyperion Planning application

we can extract security information out planning application using the following script on Planning SQL tables

SELECT A.OBJECT_ID AS GROUP_ID,
A.OBJECT_NAME AS GROUP_NAME,
D.USER_ID,
E.OBJECT_NAME AS USER_NAME,
D.ROLE,
D.SYNC_PSWD,
FROM
HSP_OBJECT A,
HSP_OBJECT_TYPE B,
HSP_USERSINGROUP C,
HSP_USERS D,
HSP_OBJECT E

Where

A.OBJECT_TYPE=B.OBJECT_TYPE
AND A.OBJECT_ID=C.GROUP_ID
AND C.USER_ID=D.USER_ID
AND D.USER_ID=E.OBJECT_id
AND B.OBJECT_TYPE ='6'
ORDER BY A.OBJECT_ID

2 comments: