data-konzept

'I received a phone call from a customer dealing with a t-sql  problem . I asked him to organise some access so I could troubleshoot the problem. When I  logged on I wanted to confirm the level of permissions.

An easy way to check for your self is to use the fn_my_permissions function. The fn_my_permissions always returns permissions in the security context of the logged in caller.

There are multiple options , but some quick ones to give a list of server and database level permissions are listed below.'...

http://www.sqlserver-dba.com/2016/05/how-to-check-my-sql-permissions.html