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

"Laurie" <laurie.kulinsky_at_wadnr.gov> a écrit dans le message de 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

Seems to me that your user has the UNLIMITED TABLESPACE privilege. Checks all his privileges with:
select privilege from dba_sys_privs where grantee='<your user>';

Regards
Michel Cadot Received on Wed Jan 21 2004 - 15:12:11 CST