Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Fusion Analytics Autonomous database Series: Creating Custom Schema
FDI 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 post provides a sample custom script that users can use to customize the script per their own use cases
This video is a part of six-part series
1- Autonomous Datawarehouse- Connecting via SQL developer
2- Autonomous Datawarehouse- Schema Exploration
3- Autonomous Datawarehouse -Using Custom Schema
4- Exploring Autonomous Data Warehouse (ADW)
5- Exploring Autonomous Data Warehouse- Performance Telemetry
Comments
-
related scripts
1 -
Hi Abhishek,
I tried providing the grants to CUSTOMDATA schema using ADMIN user login and your script for all objects under OAX_USER (also tried OAX$DW), However it's failing with "insufficient privileges"
Do i need to give this access to build semantic model extension in FAW ?
Thank you,
Prasad
0 -
@Prasad Deshpande Admin schema doesnt have ownership of any FAW Artifacts . OAX_USER has access to these artifacts via public synonyms . You need to login as OAX_USER .
0
