Forum Home » Database » Database - General

Thread: synonyms

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 2 - Pages: 1 - Last Post: May 31, 2008 7:13 AM Last Post By: Ramez S. Sawires
user633617

Posts: 79
Registered: 04/29/08
synonyms
Posted: May 31, 2008 6:38 AM
Click to report abuse...   Click to reply to this thread Reply
hi gays.

i want to prepare synonyms for some tables and provide access to user ?

please can any on help me.

Regards.
SomeoneElse

Posts: 9,551
Registered: 10/15/98
Re: synonyms
Posted: May 31, 2008 7:08 AM   in response to: user633617 in response to: user633617
Click to report abuse...   Click to reply to this thread Reply
Here is the reference manual.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm

Pay special attention to CREATE SYNONYM and GRANT.
Ramez S. Sawires

Posts: 67
Registered: 12/10/06
Re: synonyms
Posted: May 31, 2008 7:13 AM   in response to: user633617 in response to: user633617
Click to report abuse...   Click to reply to this thread Reply
I think you have to recreate the synonyms and also you have to grant it to the user

i wish that could help you

Thanks

Ramez S. Sawires
Pages: 1
Back to Thread List Back to Thread List
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums