Post reply

Managing Permissions

  • June 5, 2007 at 10:36 am

    #173970

    Hi,

    I am currently struggling with SQL 2000 security. Our vendor set up every user as "dbowner" and did not bother creating a new database role for their needs. The "public" role was not touched after they created the database.

    I could set up a database role for "EVERYONE" but I do not know what access to give each user nor does the vendor want to make that attempt.

    I would assume it would be safer, security wise to create an "EVERYONE" role and give users full access that way instead of leaving them as dbowner.

    Any recommendation would be greatly appreciated.

    Thank you,

    John Pinola Jr

  • June 7, 2007 at 4:09 am

    #711359

    Hey John,

    you can create any Security ROLE and assign what all permissions you wanna give to all the persons present in that group and then add any new Users to the same.

    Giving "dbowner" permission to everyone is not a good practice..

    -Cheers....Deeps

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply