Created
August 27, 2019 17:14
-
-
Save just1689/467e67470fa07816c04ac51257e36dd9 to your computer and use it in GitHub Desktop.
Initial setup for Oracle 12c
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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