quota

[holdingbe]

Hi all,
How to drop quota's in the oracle..


thanks
Michael

[amitpatel66]

Please provide more information/script that you have tried to work on?

[nramrits]

Hi all,
How to drop quota's in the oracle..


thanks
Michael

pls explain clearly, what do u want..

[laconicamit]

See,

To knw on which Tablespace, user had the permissions:

Eg.
Select tablespace_name from dba_ts_quotas where username=<usern ame>;

and if you want that user shud not have quota over those tablespace, you can simply alter that user:

Eg.
Alter user <username> quota 0 on <tablespace_nam e>;

I hope that solves your purpose, If I have assumed you correctly :D