This lesson describes the Oracle7 Server decentralized security system. Using the commands covered in this lesson, you can control database access to specific objects and add new users with different levels of access privileges. You can provide alternative names for objects by using the CREATE SYNONYM command. At the end of this lesson, you should be able to Explain the concept of the database security model. Describe system privileges. Set up and maintain database access by using roles. Identify object privileges. Change a password. Grant and revoke object privileges. Create synonyms for ease of table access | 16 Controlling User Access ORACLG Objectives Explain the concept of the database security model. Describe system privileges. Set up and maintain database access by using roles. Identify object privileges. Change a password. Grant and revoke object privileges. Create synonyms for ease of table access. Schedule Timing 25 minutes 20 minutes 45 minutes Topic Lecture Practice Total Class Management Note Files required for this lesson are Demonstration None Practice None This lesson should give students an overview of Oracle7 Server s security options. It is not intended to go into tremendous detail on each topic. 16-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives This lesson describes the Oracle Server decentralized security system. Using the commands covered in this lesson you can control database access to specific objects and add new users with different levels of access privileges. You can provide alternative names for objects by using the CREATE SYNONYM command. At the end of this lesson you should be able to Explain the concept of the database security model. Describe system privileges. Set up and maintain database access by using roles. Identify object privileges. Change a password. Grant and revoke object privileges. Create synonyms for ease of table access. Controlling User Access .
