Oracle Database Discussions

Hi gurus,

I'm not sure if I am in the correct forum or this thread should be in pl/sql forum, so please move it if you consider necessary.

Im working on 11.2.0.3 windows 7 and have to grant one role to several users (all users that start with "OPS$"), but i can't find a solution for myself, so i need your knowledge:

I tried:

SQL>

  1  begin

  2    for c1 in (select username from dba_users where username like 'OPS$%') loop

  3  execute immediate

  4       'grant TP_RW to ' || c1.username;

  5    end loop;

  6* end;

begin

*

ERROR at line 1:

ORA-00933: SQL command not properly ended

ORA-06512: at line 3

what i am doing wrong?