Skip to content

Instantly share code, notes, and snippets.

@kevinhooke

kevinhooke/gist:613bd956a59faa8b1500f742a4c668e8

Created March 28, 2020 22:53
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 kevinhooke/613bd956a59faa8b1500f742a4c668e8 to your computer and use it in GitHub Desktop.
Save kevinhooke/613bd956a59faa8b1500f742a4c668e8 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle create user, grant permissions, assign tablespace
Raw
gistfile1.txt
create user example identified by "password";
grant connect to example; --logon
grant select, insert, update, delete on tablename to test;
grant create table to example;
-- without assigning tablespace you get this error:
ORA-01950: no privileges on tablespace 'USERS'
alter user example quota unlimited on users;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment