How do I give a user automatic access to all databases that's being created or imported to a database server?

I have a selection of one user and two activedirectory-groups which have to automatically given access to everything created, restored and mounted. We are not able to do this manally as is appear to be at this moment.

Thank's in advanced,

  • For new databases that are created, you could try adding the user to the model database. For databases that are restored or attached, I don't know of any simple way. – Aaron Bertrand Dec 2 '13 at 14:42
  • I suspect Extended Events will be the way to go here. – db2 Dec 2 '13 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.