Skip to content

Instantly share code, notes, and snippets.

@marcosvidolin

marcosvidolin/create_user.sql

Created August 3, 2018 16:31
Show Gist options
  • Save marcosvidolin/ab6c04c340dbe9768f528c4ed9b5bdae to your computer and use it in GitHub Desktop.
Save marcosvidolin/ab6c04c340dbe9768f528c4ed9b5bdae to your computer and use it in GitHub Desktop.
Download ZIP
Create a Oracle User & Grants
Raw
create_user.sql
create user <USER> identified by <PASSWorD>;
grant connect to <USER>;
grant create session, create table, resource, connect, create procedure, create sequence, create synonym, create trigger, create view, debug connect session, unlimited tablespace to <USER>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment