Oracle Database Vault
1. I disabled the Oracle Data Dictionary Realm.
2. I used SYS to grant create session to the Orasec_User (which happens to be a "identified globally" user). this is the user we want to be able to grant create
session to other users.
3. The Orasec_user still got Realm violation after logging out and back in when trying to issue the create session grant. I tried with SYSTEM too, this same procedure, still get Realm Violation when they try to do the grant.