Add user with DDL Trigger

  • Teshome-283915

    Old Hand

    Points: 367

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

  • mrpaulandrew

    Mr or Mrs. 500

    Points: 522

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

  • Teshome-283915

    Old Hand

    Points: 367

    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.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

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

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