Insufficient Rights on tablespace...

[errodr]

I have an interesting problem that I cannot seem to crack.
I have created a new tablespace but for some reason I cannot access the new tablespace. The user I am trying to access it with has the system privilege "Unlimited Tablespace" but I am still unable to access the new table space with this user. Is there something I'm missing?

Thanks...

[patel_dil]

Could you please post the Create User syntax of that user. Also list what tablespace is giving you the problem. Maybe someone here might be able to help.

[davey23uk]

please post what you tried and what your error was

is tablespace in read only mode?

[errodr]

I don't have the create user syntax, as it is an existing user that I am trying to let access the new tablespace. I am unable to even change to that tablespace and read data, let alone write to it. I am stumped the user "appears" to have the requisite privileges (unlimited tablespace, connect, resource, etc) but I cannot access the tablespace.

[davey23uk]

ill ask again, tell us what you tried and what error you are getting

[patel_dil]

What does 'select * from user_ts_quotas' show for that user? Also check Table dba_ts_quotas. By default, all objects created by user will go in its default Tablespace. Like davey23uk asked, please provide more info on what you did and what you get.

[marist89]

Sounds like a quota problem to me...

[pnrdba]

Can you try this thing once and let us know the result .

SQL> Alter user [default tablespace ]
quota unlimited on ;

Probably your user might not have quota on that particular tablespace.



This may help

[jmodic]

I find all this a bit ridiculous. We are all guessing what the problem might be, however the whole thing would be cristal clear in a second if the original poster would put just so much effort in his description to provide the ORA error message that he gets!

Saying "for some reason I cannot access the new tablespace" does not provide us with anything usefull - it could be thousands of reasons for this.

[errodr]

Okay...

Let me make this crystal clear.
1. The user in question has the Unlimited Tablespace System Privilege
2. I am unable to access the tablespace in ANY way.
3. The error message I am getting is "Insufficient Privileges".
4. Isn't the title of my post "Insufficient Privileges on Tablespace"???

The query "select * from user_ts_quotas" only returns one row - the system tablespace.

The query "select * from dba_ts_quotas" returns no rows.

Originally posted by jmodic
I find all this a bit ridiculous. We are all guessing what the problem might be, however the whole thing would be cristal clear in a second if the original poster would put just so much effort in his description to provide the ORA error message that he gets!

Saying "for some reason I cannot access the new tablespace" does not provide us with anything usefull - it could be thousands of reasons for this.