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

Upcoming Events

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…