Skip to content

Instantly share code, notes, and snippets.

@djangofan

djangofan/create oracle user

Forked from tranminhan/create oracle user
Last active December 10, 2015 12:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save djangofan/4436831 to your computer and use it in GitHub Desktop.
Save djangofan/4436831 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create oracle user
create user usr_name identified by [pass***word] profile usr_profile default tablespace usr_ts temporary tablespace temp quota unlimited on usr_ts account unlock
grant create session to usr_name
grant create table to usr_name
grant create view to usr_name
grant create sequence to usr_name
grant create procedure to usr_name
grant create database link to usr_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment