Securing a Database Without Requiring Users to Log On
In a simple security model, it might be appropriate for all users to have the same rights to all objects in the database. In that scenario, it doesn't make sense to require users to log on. To eliminate the Login dialog box while ensuring specific objects are secure, do the following:
Once Admin's password is cleared, users are not prompted to log on, and they are automatically logged on as the Admin user. They therefore are granted any rights given to the Admin user and are denied any rights removed from the Admin user.