Create User Example

Description: Simple example to create a user.

CREATE USER username
IDENTIFIED BY password
DEFAULT TABLESPACE tablespacename
TEMPORARY SPACE temp_tablespacename
QUOTA UNLIMITED ON tablespacename;
 
GRANT CONNECT TO username;
GRANT RESOURCE TO username;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.