Skip to content

Instantly share code, notes, and snippets.

@bouassaba

bouassaba/oracle_create_schema_user.sql

Last active March 29, 2019 23:26
Show Gist options
  • Save bouassaba/9648b170235ab8e563d1e0c7eb5390f7 to your computer and use it in GitHub Desktop.
Save bouassaba/9648b170235ab8e563d1e0c7eb5390f7 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle create schema user
Raw
oracle_create_schema_user.sql
ALTER SESSION SET "_ORACLE_SCRIPT"= TRUE;
CREATE USER myuser IDENTIFIED BY myuser;
GRANT CONNECT, RESOURCE, DBA TO myuser;
GRANT CREATE SESSION TO myuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment