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

Chapter 22. Upsizing Jet Applications to... > Securing Projects with the MSDE 2000...

Securing Projects with the MSDE 2000 Login/User Tool

Adding password protection and converting your upsized project to an encoded (.ade) file doesn’t provide security for your back-end SQL Server database. You must provide groups or individual users logins to the server and permissions to read and update specific tables. Issuing a long series of OSQL statements at the command prompt is time-consuming and prone to error. Writing an OSQL script to add logins and permissions is an alternative, but isn’t an easy task.

→ For more information on creating .ade files and using the OSQL utility, see “Securing Your Project as an .ade File,” p. 848 and see “Adding User Logins with the OSQL Utility,” p. 776.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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