Re: Question on object names

Craig

The other alternative to the other posts is to use private synonyms. These need to be created by the user that will access the tables and views. Same syntax as the other posts but use "create synonym" instead of "create public synonym".

For procedures and packages, all you need to grant is the EXECUTE privilege.

HTH. Pete

Craig Despres wrote:

> We have just started development using Oracle (coming from an Informix shop)
> and I have a question on the how to access objects created on the database.
>
> When a table is created for a person's schema (owner.tablename), is there
> "GRANT" permissions, or another way to allow other users/programs to access
> this table without putting the "owner" in front of the table name? I would
> also like to know how to do the same things for other database objects,
> e.g - procedures, packages, synonyms, views, etc.
>
> Any help would be greatly appreciated.
>
> --
> Craig Despres
> Synergy Solutions Inc.

Received on Wed Sep 15 1999 - 11:15:06 CDT