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
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
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