Creating read write user for non FCUBS
In Production database if application user want trouble shoot the issue in back end,Then he wants to do DML on the FCUBS scheme.
Then due to policy restrictions you cannot be able to give application schema credentials,in that case So you can role with read and write privileges as below.
and grant to the user,so that they can login with their credential and perform the actions by this you can filter or audit who did what on the FCUBS application schema
create role RWFCUBS_TABLE_ROLE not identified;
set head off
spool table_gnt.sql
select 'grant all on ' || owner || '.' ||table_name || ' to RWFCUBS_TABLE_ROLE;' from dba_tables where owner='<FCUBS_SCHEMA>';
spool off
@table_gnt.sql
set head off
spool view_gnt.sql
select 'grant select on ' || owner || '.' || view_name || ' to RWFCUBS_TABLE_ROLE;' from dba_views where owner='<FCUBS_SCHEMA>';
spool off
@view_gnt.sql
