New answers tagged user-permissions
According to the documentation for documentation for the sys.database_permissions DMV: Any user can see their own permissions. To see permissions for other users, requires VIEW DEFINITION, ALTER ANY USER, or any permission on a user. To see user-defined roles, requires ALTER ANY ROLE, or membership in the role (such as public). And, according to ...
This would be obtained by the VIEW DEFINITION permissions. However you probably don't want to allow them access to your database servers. An alternative way would be to query the permissions on your database, and supply them with the output. This can be done using DMV's or SQL queries. There are some examples in this StackOverflow post.
After days of researching I haven't found the reason at the lowest meaningful level but slightly higher than tat. The script worked when the user it was logging in as was already logged in interactively on the machine. If I sign out of the machine, then the script stops working. This was a problem with WinRM and one of the workarounds was to use CredSSP ...
Top 50 recent answers are included