Oracle Database 11g: Storage Structures and User Security
identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators
A working knowledge of SQL
Expected Duration (hours)
Lesson Objectives Oracle Database 11g: Storage Structures and User Security
recognize the purposes of table spaces and datafiles.
recognize the steps for creating a new tablespace.
recognize how to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic Storage Management (ASM).
view tablespace information and create a new tablespace.
recognize the steps for creating and authenticating database user accounts.
recognize the steps for granting and revoking privileges and creating and managing roles.
recognize the steps for creating and managing profiles, implementing password security, and assigning quotas.
grant privileges to users in a given scenario.