To be able to grant an User access to an APU Sandbox, the User and APU Sandbox already need to exist.
Therefore, the chapter about adding or creating of the following two tutorials need to be done before being able to continue with this HowTo Guide:
¶ 1 Granting User Access to an APU Sandbox
To grant an user access to an user-managed application mart, one only has to provide the name of the user which should get access and the name of the user-managed application mart, to which the user should get access to, to the script API_SCURTY.GRANT_APU_MASTER_ACCESS.
¶ Example
EXECUTE SCRIPT API_SCURTY.GRANT_APU_MASTER_ACCESS(
'TEST_APU' -- p_sbx_name
,'TESTUSER' -- p_user_name
);
After the command above is issued, an entry will be added to the table SCURTY.SBX_MASTERS. One can see that access is granted to an user-managed application mart by looking at the 'SBX-TYPE' which will say 'APU'.
| SBX_NAME | SBX_TYPE | USER_NAME |
|---|---|---|
| TEST_APU | APU | TESTUSER |
¶ 2 Revoking User Access to an APU Sandbox
To revoke the access of a specific user to a specific user-managed application mart, the name of the user and application mart have to be provided to the script API_SCURTY.REVOKE_APU_MASTER_ACCESS.
¶ Example
EXECUTE SCRIPT API_SCURTY.REVOKE_APU_MASTER_ACCESS(
'TEST_APU' -- p_sbx_name
,'TESTUSER' -- p_user_name
);
By issuing the command above the entry showing the access of the user 'TESTUSER' to the user-managed application mart with the name 'TEST_APU' will be removed from the table SCURTY.SBX_MASTERS.