nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Fusion Analytics Autonomous database Series: Creating Custom Schema

Abhishek Bajpai - CEAL Team-Oracle

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

https://videohub.oracle.com/embed/secure/iframe/entryId/1_anlut5xv/uiConfId/35965902

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

6- Exploring Data loads with Autonomous Data Warehouse https://docs.oracle.com/en/cloud/paas/exadata-express-cloud/csdbp/create-database-schemas.html#GUID-8E89EF2D-1ED9-43BB-8B74-43D46A5B2B30

Find more posts tagged with

Database

FDI

Fusion AI Data Platform

Comments

Abhishek Bajpai - CEAL Team-Oracle

DB_Creation_Script.pdf

Prasad Deshpande

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

Abhishek Bajpai - CEAL Team-Oracle

@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 .

New Announcements

New Events

Analytics & AI Data Platform- Oracle AI and Analytics Leaders Meeting
Customers are encouraged to join this quarterly virtual meeting to hear the latest updates from Oracle Product Strategy and Product Management. There will be time at the end to network with your peers and connect with other customers who are turning their data into actionable insights with Oracle Analytics and Oracle AI…
Oracle AI Data Platform - Turn enterprise data into AI-driven business value with Oracle and Vertice
Register today! Description: Enterprise AI initiatives need more than a promising use case. They need trusted data, the right business context, and governance from the start. Join Oracle and Vertice to explore how organizations can bring these elements together to move AI use cases into production In this webinar, Oracle…
Analytics - Fusion Data Intelligence HCM Release 26R3
Join the FDI HCM Product Management Team in this live webinar to go over the topics related to Release 26R3 Agentic Capabilities Fusion Agents & Agentic Apps FDI MCP Tools OAC Data Agents delivered via FDI Content Library Workforce Scheduling - New Subject Area Learning - Analytical Currency, E-learning,…