create procedure
ksomaiya.dba_parse_$$( p_cur in number, p_str in varchar2 )
as
begin
dbms_sql.parse(
p_cur, p_str, dbms_sql.native );
end;
/
declare
exec_cursor integer
default dbms_sql.open_cursor;
rows_processed
number default 0;
sql_stmt
varchar2(255);
begin
sql_stmt := 'grant
all on ODS2.PURCHASE_ANALYSIS_CODE_MAST to ODS2_READ_WRITE';
ksomaiya.dba_parse_$$(
exec_cursor, sql_stmt );
rows_processed :=
dbms_sql.execute(exec_cursor);
dbms_sql.close_cursor(
exec_cursor );
end;
/
select * from
ODS2.PURCHASE_ANALYSIS_CODE_MAST;
select * from
session_roles;
