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.news without allowing them to browse the whole admin database? ie select * from admin.news; would work select * from admin.tel; would NOT work Thanks in advance. Klashma.
- Re: Allowing every one to query a table ? Klashma
- Re: Allowing every one to query a table ? Paul DuBois