Create maximum privileges role
Hello Oracle community
I'm trying to create a ROLE with the maximum privileges EXCEPT accessing some schema tables. The idea is to create this user as a clone of sys or system or DBA but without access to certain tables.
I can create a simple user with GRANT CREATE SESSION and then connect AS SYSOPER but maybe with some extra privileges in a ROLE and then GRANT ROLE TO that use I can reach a more powerful user.
It's possible?
Thanks