CREATE TABLE TABL (FLD CHAR);
CREATE PUBLIC SYNONYM TABL FOR TABL;
GRANT SELECT ON TABL TO OTHERUSER;
CONNECT OTHERUSER
SELECT * FROM TABL;
Craig Despres <csdespres_at_callsynergy.com> wrote in message
news:FQFD3.4472$Ms2.25272_at_news.rdc1.az.home.com...
> 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 Tue Sep 14 1999 - 23:24:49 CDT
