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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy