Database Security Products (MOSC)

MOSC Banner

execute ddl command on protected realm schema

edited Jun 17, 2025 10:15PM in Database Security Products (MOSC) 28 commentsAnswered ✓

Hi,

I need your support.

I am designing security model where DBA user can perform DDL command on protected vault realm schema ,

user_dba has dba role

app_user is the owner of application objects and protected by realm app_realm.

objective : user_dba wants to perform ddl on app_user schema ( like create table / rebuild indexes ….)

I do not want to give user_dba the relam authorization either owner or participate.

How can I implement this model ? ( i tested command rule but not work because user_dba not has auth on realm).

thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center