| ramesh |
Posted: Dec 28, 2007 11:51:49 PM |
Total Post: 69
Joined: Dec, 2006
|
How can i check that the present synonyms in my database are
PUBLIC or PRIVATE i.e. which TABLE and which FIELD
..ramesh |
|
|
 Mohammed Taj |
| Posted: Dec 29, 2007 12:08:26 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
You can check public synonyms in dba_synonym view like
select synonym_name from dba_synonyms where owner = 'PUBLIC'
and you can check private synonym in user_synonyms view.
Means any public type created synonyms goes to PUBLIC schema.
|
|
|
|
|
| ramesh |
| Posted: Dec 29, 2007 02:09:44 AM | |
|
Total Post: 69
Joined: Dec, 2006
|
Hi. Mohammed
can i change the owner of the synonym from
PRIVATE to PUBLIC if i hav the sysdba rights.
|
|
|
|
|
| Babu |
| Posted: Dec 29, 2007 04:23:29 AM | |
|
Total Post: 90
Joined: Oct, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
