Re: REMOTE USER CREATION

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
execute immediate 'create user ' || for_user || ' identified by ' || for_pw ||
 ' default tablespace users temporary tablespace temp ' ; execute immediate 'grant create session to ' || for_user; end;

Remember, the user who runs this procedure will require an explicit (not through a role) grant of the create user privilege.

HTH,
Paul

---
www.pythian.com -- vallee_at_pythian.com -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
verifications, storage management, performance and more.





----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, December 07, 2001 9:25 AM


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 Database B to
create a user in Database B. They also need to to be
able to supply username and password.
Well.....when they attempted to do that they got the
ORA error.
ORA 2064
02064, 00000, "distributed operation not supported"
// *Cause: One of the following unsupported operations
was attempted:


//         1. array execute of a remote update with a

subquery that references


//            a dblink, or

//         2. an update of a long column with bind

variable and an update of


//            a second column with a subquery that

both references a dblink


//            and a bind variable, or

//         3. a commit is issued in a coordinated

session from an RPC with


//            OUT parameters.

// *Action: simplify remote update statement

Now I am stuck with 'fixing' this.
Has anybody done or seen this anywhere.
ANy pointer would be welcome and appreciated.


TIA
Cheers,
RS

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sakthi , Raj
  INET: rajan_sakthi_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Vallee
  INET: dbalist_at_pythian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).