OraFAQ Forum: Server Administration » How to create a new user from an existing user

Home » RDBMS Server » Server Administration » How to create a new user from an existing user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create a new user from an existing user [message #170585]

Thu, 04 May 2006 07:33

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Hi All,
I need one new user to be created with same structure from an existing user without data but with only structure of the tables,procedures,views,triggers etc of the existing user.

Is there any copy command for user specific.

I hope this time my question is clear.

Thanks And Regards
Dinesh

Report message to a moderator

Re: How to create a new user from an existing user [message #170587 is a reply to message #170585]

Thu, 04 May 2006 07:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Export the source user with ROWS=n
Create the new user.Assign tablespace and quota. Do not give RESOURCE role.
Import the objects
or in 10g, use datapumps. make use of schema_remap,tablespace_remap.
More information in Oracle utilities manual and by searching this forum

Report message to a moderator

Re: How to create a new user from an existing user [message #170592 is a reply to message #170587]

Thu, 04 May 2006 07:44

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Thanks Mahesh,
I will search the forum for this.

Actually I was looking for something like a copy command.

Thanks And Regards
Dinesh

Report message to a moderator

Previous Topic:	database size
Next Topic:	Statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 14:51:58 CST 2025