Post reply

Add user with DDL Trigger

  • September 4, 2013 at 12:24 am

    #276764

    Comments posted to this topic are about the item Add user with DDL Trigger

  • September 4, 2013 at 12:26 am

    #1647187

    Hi, just wondering why you would do this and not just use the model database? Thanks

  • September 4, 2013 at 4:35 am

    #1647237

    Paul.Andrew (9/4/2013)

    Hi, just wondering why you would do this and not just use the model database? Thanks

    If you add a user in model then for every database created it will copy whatever is in the model database. One of my client want to assign user based on database name during database creation . He want to assign some user/role if the database comes from source 1 but want to assign different user and role if it comes from different source. If it is one or two database you can do it manually. We are talking over 5 databases every day. Database is attached, then analysis run on them and then dropped.

    Model db will not able to do this for me.

  • April 27, 2016 at 4:49 pm

    #1875102

    Thanks for the script.

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

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