Re: Granting Access

hi, Micheal:
try to create public synonym for the table project.

But when I log on as "myuser" and execute:

     Select * from project

*most probably, myuser do not has access to the table b'cos is under diferent schema. Example: user a created a table using his own log-in name. then the table will stored under user a schema. When user b, login he will not able to query or see the table. b'cos that table is under user a schema.

To allow user b to see the table, user a must create public synonym and grant the table to user b using this statement: create public synonym <tablename> for <synonymname>

grant all on tablename to user b

or if u everybody see it, user a just run this statement: create public synonym <tablename> for <synonymname>

regards,
tracy

Michael Hill <hillmw_at_ram.lmtas.lmco.com> wrote in message news:<4050A335.5A4549E6_at_ram.lmtas.lmco.com>...
> Michael Hill wrote:
> >
> > I granted a user some tables using the following syntax
> >
> > grant select on project to myuser
> >
> > When I look at the table privileges using:
> >
> > select * from table_privileges where grantee = 'myuser'
> >
> > I can see that "SELECT_PRIV" IS "Y" where "TABLE_NAME" is "PROJECT"
> >
> > But when I log on as "myuser" and execute:
> >
> > Select * from project
> >
> > I get an error message saying "table does not exist".
> >
> > Is there anything else that needs to be set?
> >
> > Mike
>
> Never mind I and forgotten to fully quality the table like:
>
> Select * from someserver.project
>
> Here is a good link that talks to this:
>
> http://builder.com.com/5100-6388_14-5054455-2.html
>
> Mike
Received on Fri Mar 12 2004 - 02:31:03 CET