I have created a user within Oracle Enterprise Manager, this user is the Admin of one schema. How do I restict access to other schemas in bulk, the database has about 50 schemas and the user shouldn't be able to view or interact with these other schemas.
He is not able by default, unless access to other schemas' objects has been explicitly granted to
PUBLIC. In this case, you have no easy options to restrict access to them.
You can use the following views to query for the privileges allowed for your user
FOR EXAMPLE: SELECT * FROM USER_TAB_PRIVS; --USER ALLOWED TABLE