Re: Create a user

Re: Create a user

 

  

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