Hi all, Just wondering if there is a way to listen to (like a changes feed) for the security object on a db. I will have a server full of dbs and I want to be able to know when a user has been added (or removed) from a db security object so I can send them an email.
A side question would be a query to find all the dbs a user has permissions on. I can brute force it by getting each security object on all dbs, but is there a single query? Cheers Ryan
