ALTER USER scott QUOTA 0 ON system;to restrict a user not to use a table, I got the message "system altered" but the user can still create the table. Can you explain the reason for this?
REVOKE unlimited tablespace FROM scott;The user should no longer be able to create tables in that tablespace.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.