Re: Allowing every one to query a table ?

2001-06-17 Thread Paul DuBois
At 4:38 PM -0400 6/17/01, Klashma wrote: >Hello, I am currently trying to figure out how to allow every users >that connect to my database to do a select on the table news under >database admin. I tried doing grant select on admin.news to '%' but >if seems to have failed. That's not legal GRA

Allowing every one to query a table ?

2001-06-17 Thread Klashma
Hello, I am currently trying to figure out how to allow every users that connect to my database to do a select on the table news under database admin. I tried doing grant select on admin.news to '%' but if seems to have failed. Does anyone know how to allow anyone to do a select * from admin