Re: How ,,, In SQL (GRANT)

WDH wrote:
>
> I have Financials installed. Oracle 7.1.6 and Applications 10.6.1on a
> DG platform. The programmers are using forms 4.5 to call up source
> and modify. The problem: the original source contains no owner
> references to tables, etc. How can I give the programmers access to
> all of the Applications objects so that they do not have specify the
> owner (or schema) name in the SQL? TIA.

You could create a synonym for the table in question. typically, you establish a user ID and create objects such as tables under the ID--I am not familiar with Financials, but this is good practice. Then, you could do the following:

CREATE PUBLIC SYNONYM TABLE_NAME FOR SCHEMA.TABLE_NAME Make sure that you grant SELECT, UPDATE, etc. for the rights that the developers should have on the tables from the schema ID. I have found that this has worked well in the past, though I'm sure that there are others that would disagree....

I hope that I answered your question.

Joe Received on Fri Aug 30 1996 - 00:00:00 CEST