Tablespace privilege?

[Unna]

Hi all,

I created a user with default (TESTTBSP) and temp tablespaces and granted it with roles. However, when I created a table, I got an error, "ORA-01950: no privileges on tablespace 'TESTTBSP'¡¨. I thought the privilege to the tablespace is set when the user is created with default tablespace. Can you give me advice for what should be done please?

Thanks,
Tina

[marist89]

You have to give them a quota on the tablespace. For example:

alter user xyz quota unlimited on TESTTBSP'

[jgmagnus]

check DBA_TS_QUOTAS view to determine if you have any quota on that tablespace for that user. If the user has no quota, then they will not be able to create objects there.

grant a quota to the user if this is the case. Although they might have a default tablespace, they might not have a quota on it.

- Magnus

[Unna]

Thank you all. It is the quota issue, and I have it set. Now I have no problem creating tables. Thanks a lot!