Web lists-archives.org

[Fwd: GRANT/REVOKE deny only 1 table in db from a user]

[take 2]

--
------------------------------------------------------------------------
Philip M. Gollucci (philip@xxxxxxxxxxxxxx)
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70  3F8C 75B8 8FFB DB9B 8C1C

Work like you don't need the money,
love like you'll never get hurt,
and dance like nobody's watching.
--- Begin Message --- 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

GRANT SELECT ON X.* TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X';

I need to change that slightly so that I add a more specific 'deny'

REVOKE SELECT ON X.Y TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X'

obviously this doesn't work as there is no grant defined like that.

I'm trying to avoid doing something that I have to update everytime a table is
added/deleted.





- --
- ------------------------------------------------------------------------
Philip M. Gollucci (philip@xxxxxxxxxxxxxx)
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70  3F8C 75B8 8FFB DB9B 8C1C

Work like you don't need the money,
love like you'll never get hurt,
and dance like nobody's watching.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.8 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIKImmdbiP+9ubjBwRAnxnAJ0b+fQVKK1m5IK633do4PTOySuR+wCfffSv
7ZrfoKStq3SpsA3WubumVpY=
=DQgk
-----END PGP SIGNATURE-----

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=pgollucci@xxxxxxxxxx

--- End Message ---
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx