Re: Privileges to a database

You can solve this problem in two ways:

1. When you select Client objects you must prefix the object with client.object_name. exp: select sime_thing from client.object_name;
2. You can create synonym to all objects belong to client which telling the system to substitute the prefix (client) for each object you want to select.

Have fun.
Jim.

Antonio Tortora wrote:

> I have created a database using the internal user. I then
> created the
> user for that table with the following commands:
>
> create user JohnD identified by JohnD;
> grant create session to JohnD;
> grant select on clients to JohnD;
>
> The system allows JohnD to login, but when I use the select statement
> the
> system replies. Error, Table or view does not exists.
>
> --
> Antonio Tortora
> Solar Software
> antoniot_at_iwaynet.net
Received on Wed Sep 10 1997 - 00:00:00 CEST