You may be wondering whether it is possible to find out all the privileges a user is allowed to perform with just one query. The answer is YES.
This means you could find out all the privileges a user has when they login, store the information in $_SESSION and you won't have to query the database again. Doing it this way, checking a users right to perform a certain action is extremely fast.


You will also be able to find out all the users that are able to perform a certain action on a given object with just one query as well.