This is what I use for doing those kinds of things, but I also use SA10 so this may need to change a little bit for v8: for tableFor as tableCursor dynamic scroll cursor for select st.table_name as @tableName from systab st where st.table_type = 1 order by st.table_name asc do execute immediate 'grant insert on ' || @tableName || ' to groupName'; end for; Change the answered 30 Aug '11, 18:08 Calvin Allen |
thank you very much kind sir. i used. the only real change needed is systab needs to be systable other than that it worked awesome. for tableFor as tableCursor dynamic scroll cursor for select st.table_name as @tableName from systable st order by st.table_name asc do execute immediate 'grant update, select, insert on ' || @tableName || ' to TEST_NON_DBA'; end for; answered 31 Aug '11, 09:43 izatt82 Siger Matt |