SQL Server Check User Permissions

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

Related posts:

1. .NET Compare 2 Datarows by Value Using LINQ
2. CRM Workflows Don’t Work, E-mails Don’t Send…
3. The license code is not compatible with the installed version of Microsoft Dynamics CRM
4. DataGridView Change Cell Data Type After Binding
5. Exclude Views in INFORMATION_SCHEMA