Post reply

Automatically assigning permissions after attach

  • October 2, 2008 at 11:22 pm

    #382933

    We have a system whereby users can attach databases from partners and third parties for analysis. I need to set up a policy whereby certain users automatically have read/write access to any new database that gets attached.

    Currently these users have sa privileges which I am not happy about, would just assigning them the Database Creator role suffice?

  • October 3, 2008 at 5:48 am

    #880404

    You can try to periodically run a job that checks if a new database is added. If so, grant users the permissions to that database (using dynamic SQL?).

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 2 (of 2 total)

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