User

[Arsalan]

Salam

Sir i want create user,

they should access every tablespapces in DB.

so if i mention default tablespace during the creation of user example (IRD_DATA_LARGE)

,so does he can access that TABALESPACE IN DB ?
 

create user asia identified by asia DEFAULT TABLESPACE IRD_DATA_LARGE TEMPORARY TABLESPACE TEMP2;

[ErmanArslansOracleBlog]

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)

[Arsalan]

Thanks Arsalan

for your best replay.


regard