September 16, 2008 at 8:50 am
Hi there
We have an admin user who we need to create every time a database is created. Is there a way of automating this so each time a database is created this designated user is always added to that database?
Thanks
Mark
September 16, 2008 at 9:17 am
Not that I know of. You need to add the user.
A good reason to have a script to create database instead of using the GUI. Let someone change parameters at the beginning (path, size, etc) and have the CREATE USER at the bottom of the script.
September 16, 2008 at 9:24 am
Thanks for that I had a search all over and couldn't find an answer so thought I would post this.
Thanks for the quick reply.
🙂
September 16, 2008 at 10:17 am
If you create the user in the Model database, it will be created in every new database afterward.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply