OraFAQ Forum: SQL & PL/SQL » change a table from one schema to another

Home » SQL & PL/SQL » SQL & PL/SQL » change a table from one schema to another

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

change a table from one schema to another [message #6927]

Mon, 12 May 2003 01:10

robin baby
Messages: 13
Registered: May 2003

Junior Member

can i change my table from one schema to another,i don't want to give grant all to some another schema,

Report message to a moderator

Re: change a table from one schema to another [message #6928 is a reply to message #6927]

Mon, 12 May 2003 02:00

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A schema owner inherits some implicit rights on his own objects which you cannot disable easily. What you could do instead is:
1. Create another user to access the objects wanted.
2. Create synonyms for the objects in the new schema.
3. Grant the necessary privs to the user.

This gives the user the impression he is working on his own objects (he doesn't have to prefix them) and he doesn't have ALL rights directly.

MHE

Report message to a moderator

Re: change a table from one schema to another [message #6929 is a reply to message #6927]

Mon, 12 May 2003 03:36

Naveen
Messages: 75
Registered: June 2001

Member

Hi Robin,

You can use Export and Import to change a table from one schema to another schema.

Hope this helps.

----Naveen.

Report message to a moderator

Previous Topic:	is rowid assinged incrementaly ?
Next Topic:	Vertical Total....Please help.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:07:59 CDT 2024