Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI 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
