Here is the script which you can execute to get a list of the permissions over databases.
SELECT * FROM fn_my_permissions (NULL, 'DATABASE'); GO
Here is the result set of above query when I executed with sa or admin access.
Here is the result set of above query when I executed with public access.
Reference: Pinal Dave (https://blog.sqlauthority.com)