Granting access on all tables problem

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:

I am using Oracle 11.1.0 on Windows 2008

Thanks,
Dave Received on Mon Aug 29 2011 - 04:24:55 CDT