Fusion Analytics Autonomous database Series:Set up up custom schema in Autonomous Datwarehouse

Abhishek Bajpai - CEAL Team-Oracle

FAW_Setting_up_custom schema(s)_in_Autonomous_Database_with_restricted_access.pdf

Oracle Fusion Analytics customers often want to restrict access to sensitive tables. The Blog tries to address this critical need by outlining how custom schemas can be created with tailored access.

The Blog provides a sample custom script that users can use to customize the script per their own use cases

Navnit Mishra

can you please post the script also?

Abhishek Bajpai - CEAL Team-Oracle

DB_Creation_Script.pdf

Attached Script for reference

Navnit Mishra

Thanks

Krithika Raghavan-Oracle

Thanks Abhishek for putting togther the script.

Abhishek Bajpai - CEAL Team-Oracle

additionally DW_DMD_FUNC_AREA_TABLE_MAP can help you identify the tables to Functional Area example

1- Identify the Functional Area to Table_name mapping

2- Filter on Specific Functional ara and identify and filter out tables you need to provide access for - In the below screenshot we identify all the underlying tables for Workforce Management

Users can likewise pick up any functional modules and identify the tables which are related

Navnit Mishra

good one