how to check the permissions on the database in sql server

to check the permissions on the database that a user connected to,

use the following query block,

SELECT * FROM fn_my_permissions(null,'database')

result