How to issue CREATE USER command from a stored proc?

From: Craig Harper <caharper_at_hooked.net>
Date: 1996/05/26
Message-ID: <31A82FCC.2DCC_at_hooked.net>#1/1


I am trying to figure out how to execute a CREATE USER and GRANT commands from a stored proceedure. I would like to create the username (user_id) from a sequence generator, then GRANT create session to the new user. Does anyone know if this is possible? If so how I keep getting errors when I try.

Thanks

-- 

Craig Harper 
IFTN

(v) 415.583.4528
(f) 415.583.5536
Thinking is more interesting than knowing, but less interesting than looking.
Received on Sun May 26 1996 - 00:00:00 CEST

Original text of this message