Re: REMOTE USER CREATION

2001-12-07 Thread Paul Vallee
Hi Raj, What version of Oracle are they running? This can be achieved I believe in 8.0 or later via a remote execution of a procedure that uses dynamic sql to run the create user command. Something like (in 8.1 syntax) procedure createuser (for_user in varchar2, for_pw in varchar2) is begin exe

REMOTE USER CREATION

2001-12-07 Thread Sakthi , Raj
Hi Folks, I posted this last evening and it didn't show up yet..so here we go again.. Duhvelopement Grp has decided and developed a program that is inteded to create user in remote database thru DB link. Example. The program/procedure exists in database A. They need to call a procedure in Databas

REMOTE USER CREATION

2001-12-06 Thread Sakthi , Raj
Hi Folks , Somebody tell me I am not insane...please..!! The problem is this... As usual Everybody else except DBA ( me..) decided and designed a program to create user in other database using a procedure thru db_link. Example. The programme exists in database A. When they want they have to execu