Re: Granting access on all tables problem

<test_at_m.com> a écrit dans le message de news: gemm571pdd1fjgi3un09u4pl1t9dec7pbv_at_4ax.com...
| 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

XLR is not an identifier of your block.
It is static is your statement and so part of the SQL string.

Regards
Michel Received on Mon Aug 29 2011 - 10:10:51 CDT