You can use the alter user-statement to change the amount of space that a user can utilize in a tablespace:
alter user userName quota 100M on temp;
alter user userName quota 0M on system;
If the user has the system privilege "unlimited tablespace" it overrides the quota on each tablespace and gives unlimited quota.
No comments:
Post a Comment