Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create users in Personal Oracle 7?
You could try creating public synonyms of the tables that you wish to grant access to and grant access to the synonyms.
You must be the owner of the table to grant full permissions on the synonym that references the table or object.
CREATE PUBLIC SYNONYM <name> FOR <name>
hope this helps
On Mon, 16 Jun 1997 17:44:41 -0700, bakhtiar <bakh_at_cosmopt.po.my> wrote:
>Hi!
>
>I am trying to create new users in PO 7. I am able to create them. But
>I am not able to grant any rights to any of the other users tables (I
>login as SYSTEM to do the grant).
>
>Please help.
>
>Thanks
>
>Mani
Received on Mon Jun 16 1997 - 00:00:00 CDT