OraFAQ Forum: Server Administration » Changing Database Owners

Home » RDBMS Server » Server Administration » Changing Database Owners

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

Changing Database Owners [message #110131]

Thu, 03 March 2005 11:30

andyboy_uk
Messages: 1
Registered: March 2005
Location: London UK

Junior Member

Hi there,

Its been a very long time since I did anything with Oracle but I have been asked a question that I wanted to put to this group.

Im assuming that oracle has the same thing as SQL where a database can have an owner. So if i have a database owned by BILL and I want to change the owner to BEN, I would use the sp_change_users_login command in MS SQL.

How would I do that in Oracle?

Thanks in advance,
Andy D

Report message to a moderator

Re: Changing Database Owners [message #110167 is a reply to message #110131]

Thu, 03 March 2005 15:54

kapil2005
Messages: 44
Registered: March 2005

Member

I would create a new user Bill and copy all objects from ben to Bill and drop user Ben

Report message to a moderator

Re: Changing Database Owners [message #110201 is a reply to message #110131]

Fri, 04 March 2005 01:46

Frank
Messages: 7901
Registered: March 2000

Senior Member

You could export BILL's objects and import them using the fromuser=BILL touser=BEN clause of the IMP utility.

There is no way (as far as I know) to really change the ownership of objects.

hth

Report message to a moderator

Previous Topic:	ORA-28527: Heterogeneous Services datatype mapping error
Next Topic:	Emailing from pl/sql on Oracle9i - Running initplsj.sql in oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 04:03:30 CST 2025