• RonKyle - Tuesday, September 26, 2017 7:23 AM

    At previous companies we were assigned an admin account and a regular account.  Only used the admin account when necessary.  Even on my home machine I do most things from a standard account.  It would drive me crazy when my sons would need me to type in the admin password just so they could play games.  I couldn't understand why the game program needed admin access to the computer.

    Poor developers, and poorly documented security, or poor separation of duties. I thought the same thing for Great Plains accounting years ago needing SA. Why? Only one thing, adding new logins and users. Even allowing securityadmin seemed crazy. At that time, we ended up giving dbo (SQL 2000) in the db, and creating the logins manually. The app could add a user mapped to a login, so we required a ticket for new users. More secure, a few times a year work for DBAs.