<div>
Create and Drop operations of Public synonyms are allowed by users who have been granted privileges &quot;create public synonym&quot; and &quot;drop public synonym&quot;.<br />
<br />
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.<br />
<br />
HTH
</div>


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

<div>
ok, but let's say now I want to edit the synonym to point to another schema, how do I do that?
</div>


ok, but let's say now I want to edit the synonym to point to another schema, how do I do that?

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Accept rramineni's comment as answer.<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
Henka<br />
EE Cleanup Volunteer
</div>


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

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Thanx <br />

</div>
</div>


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 


Create,alter ,dropping a public synonym

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.