Re: User

Posted by ErmanArslansOracleBlog on Dec 19, 2016; 8:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/User-tp1769p1770.html

If you need to create object in your default tablespace;

Create your user with quota syntax.

Example
CREATE USER app_user1
   IDENTIFIED by "123456"
   DEFAULT TABLESPACE example
   QUOTA unlimited ON example;

so you need to give quota on related tablespace to user.

You need to give other grants as well.. Such as creation session, create any table and so on.. (grants according to your needs)