Hi all,

I'm trying to have these lines below as part of a procedure

cSql_statement:='create user '||AddNewFITSUser.MDSUser||' identified by '||AddNewFITSUser.MDSUser;

execute immediate cSql_statement;

cSql_statement:='grant maintenance to '||AddNewFITSUser.MDSUser;

execute immediate cSql_statement;

compiler didn't complain nor when I was calling the procedure, it said procedure executed successfully. But when I check the user, it wasn't created. Anybody know why?

Thanks.