How to determine effective permission of an SQL Server 2005 object?

You can find out the effective permissions on an SQL Server 2005 object by using a function called fn_my_permissions. Here’s what’s written in the books online. fn_my_permissions  Returns a list of the permissions effectively granted to the principal on a securable. Syntax fn_my_permissions ( securable , ‘securable_class’) Arguments securable Is the name of the securable. [...]