Oracle grant access to all views for a user
begin
for x in ( select VIEW_NAME from DBA_VIEWS WHERE OWNER = ‘INTMAN’ )
loop
execute immediate ‘grant select on INTMAN.’ || x.VIEW_NAME || ‘ to HR_USER’;
end loop;
end;
Oracle grant access to all views for a user
begin
for x in ( select VIEW_NAME from DBA_VIEWS WHERE OWNER = ‘INTMAN’ )
loop
execute immediate ‘grant select on INTMAN.’ || x.VIEW_NAME || ‘ to HR_USER’;
end loop;
end;