Another quick solution for users of MSSQL Server.

To view the permissions the current logged SQL user has, use the command

SELECT * FROM fn_my_permissions(NULL, 'DATABASE')

or variations to return a list of SQL commands permitted.

For more details, visit the MSDN page