Hi, I have an acctA which needs to 'select' on acctB's tables,views,stored procedures, all things own by acctB. AcctB owns over 100,000 tables,views.
What is the best way to grant 'select' to acctA on the acctB objects?
Is there a better way than the statement below?
select 'grant select on '||table_name||' to acctA;' from dba_users where owner='acctB';