Chapter Summary

This chapter showed you how to use Jet DDL statements to manage security in the Microsoft Access database. You used the ALTER DATABASE statement to create, modify, and remove the database password and managed the user-level accounts with the CREATE, ADD, ALTER, and DROP statements. You learned how to use the GRANT and REVOKE statements to establish and remove permissions on database objects for user and group accounts.

In the next chapter, you learn how to organize your data using structures known as views, and how to use stored procedures in lieu of Access Action and Parameter queries.

0 0

Post a comment