Starting with SQL Server 2005, the sys.fn_my_permissions function can be used. It has a quite simple syntax: fn_my_permissions ( securable , 'securable_class') To answer the question, the code would be: 1 2 3 USE MyDatabase; GO SELECT * FROM fn_my_permissions
Read More...