alter user scott quota unlimited on data_tablespace
If I give scott unlimited quota on data_tablespace and I want to revoke that priveledge,
Is that possible? If so, what's the syntax to do that?
Printable View
alter user scott quota unlimited on data_tablespace
If I give scott unlimited quota on data_tablespace and I want to revoke that priveledge,
Is that possible? If so, what's the syntax to do that?
quota is not a privilege. To reduce scott's quota, you would:
alter user scott quota 60M on users;
Hi,
Give the follwoing command to revoke or give 0 quota on users tablespace .
alter user scott
quota 0 on users;
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]