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
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 IFTNReceived on Sun May 26 1996 - 00:00:00 CEST
(v) 415.583.4528
(f) 415.583.5536
Thinking is more interesting than knowing, but less interesting than looking.