Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add user with DDL Trigger Expand / Collapse
Author
Message
Posted Wednesday, September 4, 2013 12:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 25, Visits: 541
Comments posted to this topic are about the item Add user with DDL Trigger
Post #1491146
Posted Wednesday, September 4, 2013 12:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 97, Visits: 129
Hi, just wondering why you would do this and not just use the model database? Thanks
Post #1491147
Posted Wednesday, September 4, 2013 4:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 25, Visits: 541
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.



Post #1491217
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse