How are users able to create records when their tablespace quota is set to none ? I had thought that maybe they used the quota of the schema owner, but I changed that user's quota to none and records could still be created by other users.
Printable View
How are users able to create records when their tablespace quota is set to none ? I had thought that maybe they used the quota of the schema owner, but I changed that user's quota to none and records could still be created by other users.
It then uses default tablespace USERS.
Quotas setting for user A inserting into table of user B is irrelevant. As long as user B has not filled up his quota user A will be able to insert into B's tables.
If you revoke B's quota, his objects allready created in that tablespace are not affected. As long as there is free space in them all users will be able to insert into them. But once the table fills up, it has to allocate a new extent the next time someone wants to insert a new record. But as there is no quota available for user B, the insert will fail with some ORA error ("... insuficient quota in tablespace ....")
HTH,
Thanks for the help. I could not find any resource which explains this.