Rabus wrote:
Hi Robin & list,
-----Original Message----- From: Robin H. Johnson
On Mon, Mar 24, 2003 at 09:37:00AM -0500, Marc Delisle wrote:
Well, after reading their answer, I guess we will have to rely on something else to set $is_superuser, like selecting records from mysql.user.
Agreed. We will have to just follow how GRANT/REVOKE work and build up the permissions ourselves. Or use SHOW GRANTS and some work.
Please avoid SHOW GRANTS. It's a little buggy in early 4.0 / 3.23 versions. And the big problem is that we have to know the correct Hostname as it appears in the user table. e.g. if user foo@192.168.0.% logs on from 192.168.0.26 we would intentionally build this query: SHOW GRANTS FOR foo@192.168.0.26; Unfortunally, this query would fail. The only way to determine a user's privileges properly is to use the `mysql` database. We should use the controluser for this purpose.
Alexander M. Turek alex@bugfixes.info
Change implemented in main.php3.
Marc