Oracle connections
Dear Community,
I need to create 4 users with specific roles and prevent them from accessing some schemes if possible.
- USER1 with CREATE SESSION, SYSDBA and SYSOPER (SYS clone))
- USER2 with ALL PRIVILEGES (SYSTEM clone)
- USER3 with CREATE SESSION, RESOURCE and DBA (for DBA)
- USER4 with CREATE SESSION and REAN ON schema 1 and schema 2 (read-only access)
Is it possible to REVOKE privileges on USER3 to access schema 3?
Thanks
Paulo
0