view permissions read only on a database?

Question

view permissions read only on a database?

anzz

SSCertifiable

Points: 5503
More actions
January 9, 2014 at 1:28 pm

#280944

we want to grant read only access to developers to look at the permissions.
how to perform this action?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ivan Donev SSC Eights! Points: 957 More actions · Answer 1

What is your SQL Server version and which permissions exactly you need to look at - server level, database level, Windows level?

In any case - you could explore the possibility to create a stored procedure with EXECUTE AS integrated. Then just give exec permissions only on that procedure. (that is just an option, depending on the details, there might be another one).

HTH,

Ivan

anzz SSCertifiable Points: 5503 More actions · Answer 2

1) SQL 2012

2) To a developer, look at the permissions at database level.

Ivan Donev SSC Eights! Points: 957 More actions · Answer 3

Hi Ranzz,

In that case you can use the mentioned method - just write a simple stored procedure, that will list the permissions you need. More details on permissions and what DMVs you can use you can find here and here.