How to revoke all privilege for user in his own schema.
eg: if we have a user A in database 11.2.0.4, and i want that only connection to user nothing else.
Like i dont want to user give persmision for creation table and also insert/update/delete/drop.. i want his all DDL and DML to be revoke. So that he can't do anything these DDL/DML transaction in his own schema.
Is there a way to do that?
Kindly help me with this