Skip to content

Instantly share code, notes, and snippets.

@humbertodias
Created April 4, 2018 13:56
Show Gist options
  • Save humbertodias/1e887129472f218e7688a402592d45df to your computer and use it in GitHub Desktop.
Save humbertodias/1e887129472f218e7688a402592d45df to your computer and use it in GitHub Desktop.
Oracle 12c fix legacy script
-- fix for oracle 12c
alter session set "_ORACLE_SCRIPT"=true;
-- USER SQL
CREATE USER crudtest IDENTIFIED BY "crudtest" ;
-- QUOTAS
-- ROLES
GRANT "DBA" TO crudtest ;
ALTER USER crudtest DEFAULT ROLE "DBA";
-- SYSTEM PRIVILEGES
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment