User 'wj' attempts to perform a 'Select' command on the 'oats' database. Server looks towards the user table. Server then looks toward the db table. User 'wj' connection attempt successful. User 'wj' attempts to perform a 'Select' command on the 'oats' database.
Server looks towards the user table.
Since the privileges granted within the user table are global, the request is successfully carried out. User 'wj' connection attempt successful. User 'wj' attempts to perform a 'Select' command on the 'oats' database. Server looks towards the user table. Server now looks towards the db table.