Hi there..
I am not understanding something how the mysql priviege system works:
I want to do the following:
Give a user access to all tables in an database (also tables which will be added in
the future) except a
few private tables like the mysql table itself
This is the way I thought it should be done:
Add a user: '%','username','password','Y',Y','Y','Y','Y','Y','N','N' etc//
Then add the following to table db
'%',mysql','username','N',N','N','N','N','N','N','N' etc//
Run the Flush privileges command and try it..
This doesn't work! Or I am missing something..
When I think logically, I can maybe understand that the DB looks at the user table and
sees that the uses has access to do everything and doesn't look further at de db
table..
Is this correct? What is then the solution to do what I described above..
I looked at the manual, but I can't seem to figure out in what order the tables are
checked..
Does it stop looking further when he finds permission to do something or does it stop
at the first 'N'...
PS: I am not planning to use the above example, but it will help me understand how the
privilege system works..