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