Re: Looking for Add Same User SQL simliar to NT "Security Manager"

From: Aj <ajkumar_at_earthlink.net>
Date: Sun, 3 Jan 1999 21:34:51 -0500
Message-ID: <76p9a7$h98$1@fir.prod.itd.earthlink.net>

Pet

Try to generate a script for the Database. Info about Users are stored in the Database....

SET HEADING OFF select 'CREATE USER '||'&New_USER_NAME'||' IDENTIFIED BY '||'&New_PASSWORD' || ' DEFAULT TABLESPACE '||DEFAULT_TABLESPACE||' TEMPORARY_TABLESPACE '||TEMPORARY_TABLESPACE
FROM DBA_USERS
WHERE USERNAME = UPPER('&Current_USERNAME')

This is just a small example..... This creates the script for the new user based on the existing one.

HTH Aj

Peter Kellner wrote in message <369014c7.14425072_at_news.conxion.com>...
>Under NT.. Oracle Enterprise Manager / Security Manager .. You can
>create a new user by saying "Create Like" after selecting an existing
>user. I want to make a script that will do a similar thing in adding
>a new user. Is there anyway to get the syntax of the sql that the
>secuirty manager is issuing?
>
>thanks
Received on Sun Jan 03 1999 - 20:34:51 CST