Create,alter ,dropping a public synonym

Amohelang
Amohelang used Ask the Experts™
on
I'm using oracle 8i, and I'd like to know how to create, edit ,drop a public synonym and where do you do all that, i.e in the schema itself or do you have to be outside the schema which you want to create the synonym for.

Thanx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Create and Drop operations of Public synonyms are allowed by users who have been granted privileges "create public synonym" and "drop public synonym".

Once the synonyms have been created any user with drop public synonym privilege can drop it and vice versa. It need not be the owner of the object or the user who have created the synonym.

HTH

Author

Commented:
ok, but let's say now I want to edit the synonym to point to another schema, how do I do that?
You need to drop and recreate a new synonym. There is no alter synonym.
Helena Markováprogrammer-analyst

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept rramineni's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial