Configure Oracle Database Vault: Creating a New User in a Secured Environment
Configure Oracle Database Vault: Creating a New User in a Secured Environment Oracle Database Vault is a powerful security component that enforces separation of duties and limits access to sensitive data, even from DBAs. When Database Vault is enabled, traditional user creation and privilege management are restricted and must be done by authorized DV accounts . This blog walks through the steps to create a new user (SCOTT) in a PDB ( pdb1 ) within a Database Vault-enabled environment . Scenario You are working in a multitenant environment with Database Vault enabled . You attempt to create a user in pdb1 , but face privilege errors. Let's walk through the proper method to do this securely and successfully. Step 1: Switch to Target PDB First, ensure your session is connected to the appropriate Pluggable Database : sql ALTER SESSION SET CONTAINER = pdb1; Step 2: Attempt to Create a User (Fails with ORA-01031) Now, try to create a new user: sql CRE...