Re: Granting access on all tables problem

>Hi,
>
>I am having problems granting access to all tables to a role. I have
>tried the following I found in the internet ....
>
>
>begin
>for i in (select table_name from all_tables) loop
>execute immediate 'grant select on ' || i.table_name || ' to ' || XRL;
>end loop;
>end;
>/
>
>I created the user XRL and granted it CONNECT and RESOUCES but when I
>run the dynamic sql I get the following error
>
>error at line 3:
>ORA-06650: line 3, column 64
>PLS-00201: identifier 'XLR' must be declared
>ORA-06550 line 3, column 1:
>PL/SQL: Statement ignored.
>
>I am using Oracle 11.1.0 on Windows 2008
>
>Thanks,
>Dave

Thanks Michel and Robert for the help!
It is working now.

Dave Received on Mon Aug 29 2011 - 13:29:16 CDT