Privilege question

It it possible to allow access to all tables in a database *except* one... What I was hoping to do was say: GRANT ALL ON mydb.* TO [EMAIL PROTECTED] ; REVOKE ALL ON mydb.secrettable TO [EMAIL PROTECTED] ; -- but it doesn't work like that... I can only revoke stuff that's previously been specifi

Re: Privilege question

"Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I saw in the online manual > > http://www.mysql.com/doc/en/SET_OPTION.html > http://www.mysql.com/doc/en/Privileges.html > > > A SUPER PRIVILEGE mentioned. How does it differ from the GRANT privilege ? GRANT option allows you to give your privile

Privilege question

Hi MySQL Fans ;-); I saw in the online manual http://www.mysql.com/doc/en/SET_OPTION.html http://www.mysql.com/doc/en/Privileges.html A SUPER PRIVILEGE mentioned. How does it differ from the GRANT privilege ? I would appreciate if anybody could point me to some more detailed infomation of ea

Access denied & database privilege question

Hi list, I've a question about the database privilege and the Mysql.db table. If i do something like this : GRANT SELECT ON MYDB.* TO [EMAIL PROTECTED]; ( i'm using MyISAM tables ... ) And if MYDB contains something like 100 tables, could this make me problems ? In fact, i have errors like this :

Re: Column Privilege Question

At 11:26 AM -0400 5/3/01, David C. Troy wrote: >Hi, List! > >I have a table. The table has columns A, B, and C. > >I want User1 to be able to read columns A,B, and C, but I want User2 to >only be able to read column A. > >Is this possible using MySQL columns_priv security? Yes, use the GRANT sta

Column Privilege Question

Hi, List! I have a table. The table has columns A, B, and C. I want User1 to be able to read columns A,B, and C, but I want User2 to only be able to read column A. Is this possible using MySQL columns_priv security? Thanks, Dave ===

Re: Mysql privilege question

Fai wrote: > > According to MySQL rule, the column matching order in mysql database should be as >following: > ++-+- > | Host | user| > ++ +- > |localhost| |root ||localhost| | ||pit.sample.com |root >||pit

Mysql privilege question

According to MySQL rule, the column matching order in mysql database should be as following: ++-+- | Host | user| ++ +- |localhost| |root ||localhost| | ||pit.sample.com |root |||pit.sample.com | |