Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Fusion Analytics Autonomous database Series:Set up up custom schema in Autonomous Datwarehouse
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
Comments
-
can you please post the script also?
1 -
Attached Script for reference
4 -
Thanks
1 -
Thanks Abhishek for putting togther the script.
1 -
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
4 -
good one
1
