I have searched a lot about "How to allow access of One User only on One Schema", but not found any convincing solution. I have read about GRANT and REVOKE but found the solutions like grant or revoke the permissions on a particular tables for particular user.
What I am looking for is, When having multiple Users, each have access to defined Schema's and one user will have full access rights to One Schema. And I don't want one user to access the other Schema's except the one for which access rights are given.
Please suggest how to exactly use the GRANT or REVOKE to perform this ?