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

2008-05-15 Thread Philip M. Gollucci
[take 2] -- Philip M. Gollucci ([EMAIL PROTECTED]) 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

GRANT/REVOKE deny only 1 table in db from a user

2008-05-12 Thread Philip M. Gollucci
-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