Access objects priority

[expired user #6914]'s profile image [expired user #6914] posted 11 years ago in General Permalink
In case we defined multiple access objects to 1 user, which ones are evaluated first?
For example:
user1
allow SELECT,INSERT,UPDATE access to db1
allow SELECT access to db1.table1

will the user have INSERT access to db1.table1?

Cheers
Paulo
ansgar's profile image ansgar posted 11 years ago Permalink
Yes, definitely, as db1 includes table1. Second privilege is ineffective.
[expired user #6914]'s profile image [expired user #6914] posted 11 years ago Permalink
thanks smile

Please login to leave a reply, or register at first.