This week introduces the basic techniques to database security management, including user management, privilege management, and resource management. Upon completion of this chapter, you will have the following understanding:

1. How to create a user and assign password.
2. How to assign tablespace for a user.
3. Understand the system privilege and object privileges.
4. How to grant and revoke privileges.
5. Understand, know how to grant/revoke role privileges.
6. How to assign tablespace quota.
7. Know how to manage resource limit profile.

Students: The majority of the content for this week is available in Chapter 7 in your textbook.

Have fun.

 

School of Technology
College of Business & Applied Sciences
Eastern Illinois University