Home Forums SQL Server 2014 Development - SQL Server 2014 How to check the user which revoked the object permission RE: How to check the user which revoked the object permission
Ant-Green
SSC Guru
Points: 113445
More actions
November 24, 2015 at 1:27 am
#1841939
Could also check sys.database_permissions and join back to sys.database_principles on the grantor to see which login did it. But if its a group then you will need to check the trace as Jack has already mentioned if it hasn't rolled over already.