Hi Experts ,
We have multiple schemas in our database , need to grant the read only (select on ) access for all the schema's tables to support team , for that we have created a separate role
like SUPPORT_READONLY and trying to grant the select provilleges with below option but its not working seems since the support user(APP_L2) still getting table or view does not exists.
BEGIN
FOR t IN (SELECT *
FROM dba_tables
WHERE owner in ('ACC_MAST','REF_OWNER','GKP_OWNER')
LOOP
EXECUTE IMMEDIATE 'GRANT SELECT ON ' ||
t.owner || '.' || t.table_name ||
' TO SUPPORT_READONLY';
END LOOP;
END;
Its executed successfully .
and
GRANT SUPPORT_READONLY to APP_L2;
Granted that role to user
but they are not able to access getting table view does not exists
select * from ref_owner.emp_info ;
Can you please assist ?
Thanks,
Arun,