Re: User with NO tablespace quota can still accesss and write to tablespace!

laurie.kulinsky_at_wadnr.gov (Laurie) wrote in message news:<2e87f958.0401211126.1ba8c7c9_at_posting.google.com>...
> Ok.... 9.2 of Oracle on Sun...
>
> I built a test database a while back and am testing some user access
> stuff.
>
> When I create a user with NO tablespace quota, and only the connect
> role (even backed this back to the create session role), the user can
> still create tables and insert data into the tables regardless of the
> quota given to that user, be it no quota or even limited. If limited,
> the users can blow right past that mark. Also the user can move the
> table to any other tablespace on the database (no quota on those
> tablespaces either)! A bad thing....
>
> Our other databases do not display this behavior and are all the same
> version of Oracle....
>
> Has anyone come across this?? Any ideas??
>
> Last resort will be to log a TAR, didn't see anything quite like this
> in Metalink...
>
> Thanks ;)
> Laurie

OK Here is the Answer!

The user owned the table but had no other privilage or role granted than create session.

BUT Public had unlimited tablespace granted. So my user was picking up the unlimited by way of Public...... Once it was removed from Public, all was well again....

Thanks for all your feedback!

Laurie ;) Received on Thu Jan 22 2004 - 10:39:34 CST