• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Database Security Made Easy > Securing a Database Without Requiring...

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:

1.
Open the database you wish to secure.

2.
Run the Security Wizard. If you wish an object to be available to users, grant the appropriate permissions to the Admin account. Clear the permissions for any objects you don't want users to have access to.

3.
Make sure that Admin's password is cleared. This will keep the Login dialog box from appearing.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint