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
