if you are using 8i it will be much easier to do this:
EXECUTE IMMEDIATE 'CREATE USER '||v_userid||'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
IDENTIFIED BY '||v_passwrd||' ;
GRANT viewA viewB viewC TO '||v_userid;
|
Results 1 to 5 of 5
Thread: PL/SQL Scripting Error.Threaded View
|
Click Here to Expand Forum to Full Width |