Skip to content

Instantly share code, notes, and snippets.

@just1689
Created August 27, 2019 17:14
Show Gist options
  • Save just1689/467e67470fa07816c04ac51257e36dd9 to your computer and use it in GitHub Desktop.
Save just1689/467e67470fa07816c04ac51257e36dd9 to your computer and use it in GitHub Desktop.
Initial setup for Oracle 12c
CREATE USER just1689
IDENTIFIED BY penguins;
CREATE USER COR
IDENTIFIED BY penguins;
GRANT create session TO just1689;
GRANT create table TO just1689;
GRANT create view TO just1689;
GRANT create any trigger TO just1689;
GRANT create any procedure TO just1689;
GRANT create sequence TO just1689;
GRANT create synonym TO just1689;
GRANT Alter TABLESPACE to just1689;
GRANT create tablespace to just1689;
GRANT UNLIMITED TABLESPACE TO just1689;
GRANT CONNECT, RESOURCE, DBA TO just1689;
GRANT ALTER TABLESPACE TO just1689;
ALTER USER just1689 quota unlimited on USERS;
ALTER USER COR QUOTA UNLIMITED ON USERS;
GRANT UNLIMITED TABLESPACE TO just1689;
GRANT UNLIMITED TABLESPACE TO COR;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment