?

Log in

No account? Create an account

[icon] Dear lazyweb: MySQL permissions - Patti
View:Recent Entries.
View:Archive.
View:Friends.
View:Profile.
View:Website (pattib.org).

Security:
Subject:Dear lazyweb: MySQL permissions
Time:04:40 pm
For someone who knows a lot about MySQL permissions... I think the answer to this is no, but I'm not an expert. Is there any way to accomplish this end result: GRANT SELECT on (everything but one thing) to ..." ? Basically, I want an account that can read everything except one or two specific pieces of data.
comments: Leave a comment Previous Entry Share Next Entry


evwhore
Link:(Link)
Time:2009-06-15 11:55 pm (UTC)
I don't claim any expert/wizard status but I am pretty sure the answer is no.
(Reply) (Thread)


bittercrackbaby
Link:(Link)
Time:2009-06-16 12:23 am (UTC)
Unfortunately, you can't really do that. You can either grant wildcard exampledb.* or you'd have to have separate entries per table. Precedence for privileges goes from user/db/table/column so you couldn't revoke access to a table even if it was allowed.
(Reply) (Thread)


whipartist
Link:(Link)
Time:2009-06-16 12:24 am (UTC)
Thanks. That's what I thought, but I didn't know if there were any tricks.
(Reply) (Parent) (Thread)

[icon] Dear lazyweb: MySQL permissions - Patti
View:Recent Entries.
View:Archive.
View:Friends.
View:Profile.
View:Website (pattib.org).