Hi,
Not really an answer to your Q, but if the procedure is created by a user
with create any table privileges you can create tables in another schema
right?
So simply create your user and then create the tables in that new users
schema, no need to connect as that user.
Jack
You can't, but you can use 'alter session set
current_schema = ...'. Similarly, if the procedure
you're building has all the power the create users/
create tables, then it will be able to put data in
that table, it can also be used to temporary create a
secondary procedure in the new schema to is
Dear DBA Gurus,
I want to create a stored procedure in which a name is passed as
input parameter. The procedure should take the name as input parameter and
create a user with the username and password same as name. Then I want to
connect as the newly created user and create a set of tab