Explanation on INFORMATION_SCHEMA.RIGHTS

What is the purpose of this table? From it's name, could we assume that it lists all rights assigned to each user?

If we need to know what right are assig开发者_开发百科ned to which user, should we look only this table? Or there is another table to read?

What is the purpose of this table?

It contains the list of rights of users and roles.

Or there is another table to read?

Yes. You also need to know what roles are assigned to a user: INFORMATION_SCHEMA.ROLES