Re: own privileges

2003-08-27 Thread Egor Egorov
[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 c

RE: RE: own privileges

2003-08-27 Thread P.Gertman
>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: ht

Re: own privileges

2003-08-25 Thread Victoria Reznichenko
[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_GRAN

Re: own privileges

2003-08-25 Thread Nils Valentin
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.

RE: own privileges

2003-08-25 Thread Jay Blanchard
[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 Ge

own privileges

2003-08-25 Thread P.Gertman
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]