Oracle9i Database Admin Manage Security

This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.

• Define and maintain the five components of the security domain of a user in a given environment.
• Define and maintain a named set of resource and password limits.
• Demonstrate the use of resource limits and how to set them.
• Manage system and object privileges.
• Control the administration of privileges in a database.
• Demonstrate the use of concepts and skills to keep track of the various events occurring in an Oracle9i database.

The intended audience for this course include Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Additionally, learners should have taken the first four parts of this series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Conceptual

NASBA credits: 4 CPE Credits

American English

6 to 8 hours

1 - 2 hours
• Match the components of a security domain with their functions.
• Identify the steps for creating a user.
• Create a user by using Oracle Security Manager.
• Identify the security feature available to an operating system user when a value for the OS_AUTHENT_PREFIX parameter is given.
• Identify the guidelines for creating a user.
• Maintain passwords by using Oracle Security Manager.
• Maintain account locks by using Oracle Security Manager.
• Change the user quota on a tablespace by using Oracle Security Manager.
• Drop a user by using Oracle Security Manager.
• Display the tablespace quotas for users from the data dictionary using Oracle SQL*Plus Worksheet.
• Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet.
Unit 2: Managing Resources and Password Security

1 - 2 hours
• Identify the uses of profiles.
• Create a user profile.
• Assign a profile to an existing user by using Oracle Security Manager.
• Alter a user profile to modify resource limits using Oracle Security Mana

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD

Training Presented in: English