Post reply

Creating a default user

  • September 16, 2008 at 8:50 am

    #127524

    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

    #872465

    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

    #872474

    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

    #872527

    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