CREATE USER XYZ PROFILE "DEFAULT" IDENTIFIED BY xyz DEFAULT TABLESPACE
USERS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK
GRANT "CONNECT" TO "XYZ"
> Hi gurus,
>
> I wana create user like any existing user along with all
> priviliges and roles.
>
>
>
> Regards
>
> Khan
>
> .
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
+--oOO-----Ooo--+
Yoseph I Fahed
Senior DBA
6656-210
+--oOO-----Ooo--+
Oracle LazyDBA home page