RE: RE: own privileges
User can use SHOW GRANTS command: Thank you! But one more question: what privileges user should have to issue this command? I've got a user who has rights only to SELECT from certain db. What should i GRANT to him to allow use of SHOW GRANTS? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: own privileges
[EMAIL PROTECTED] wrote: User can use SHOW GRANTS command: Thank you! But one more question: what privileges user should have to issue this command? I've got a user who has rights only to SELECT from certain db. What should i GRANT to him to allow use of SHOW GRANTS? Every user can see his own grants. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: own privileges
[snip] Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some table? I'm using PHP4 [/snip] Of course! If they have access to a query on the mysql.user table they can see their permissions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: own privileges
SHOW GRANTS FOR [EMAIL PROTECTED]; It is important that the mix of username and hostname is the one which is specified in the privilege database. Please see the manual for details. show grants for [EMAIL PROTECTED]; ++ | Grants for [EMAIL PROTECTED] | ++ | GRANT ALL PRIVILEGES ON *.* TO 'root | ++ 1 row in set (0.09 sec) Best regards Nils Valentin Tokyo/Japan 2003 8 25 21:[EMAIL PROTECTED] : Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some table? I'm using PHP4 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: own privileges
[EMAIL PROTECTED] wrote: Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some table? I'm using PHP4 User can use SHOW GRANTS command: http://www.mysql.com/doc/en/SHOW_GRANTS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]