March 18, 2008 at 12:39 pm
I am wondering if a DDL trigger can be written to grant db_datareader access to a given login each time a new database is created for the newly created database.
March 18, 2008 at 12:46 pm
...Since Model is used to create the new databases, if you set up a user to have datareader access in Model, by default that user will have datareader in every new database from then on....
Look Ma - no Trigger!
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 18, 2008 at 1:00 pm
WOW.... Thanks Matt. Guess I need to go back to the coffee machine. I tried to make this way too difficult.
March 18, 2008 at 1:37 pm
Edogg (3/18/2008)
WOW.... Thanks Matt. Guess I need to go back to the coffee machine. I tried to make this way too difficult.
don't sweat it - it took me a long time to finally catch on to what Model is for... Just passing on the knolwedge!
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply