Re: Granting access on all tables problem
Date: Mon, 29 Aug 2011 17:10:51 +0200
<test_at_m.com> a écrit dans le message de news: gemm571pdd1fjgi3un09u4pl1t9dec7pbv_at_4ax.com...
| I am having problems granting access to all tables to a role. I have
| tried the following I found in the internet ....
| for i in (select table_name from all_tables) loop
| execute immediate 'grant select on ' || i.table_name || ' to ' || XRL;
| end loop;
| 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
XLR is not an identifier of your block.
It is static is your statement and so part of the SQL string.
Michel Received on Mon Aug 29 2011 - 10:10:51 CDT