15
Copyright © Oracle Corporation, 2002. All rights reserved.
Managing Users
15-2 Copyright © Oracle Corporation, 2002. All rights reserved.
Objectives
After completing this lesson, you should be able to do
the following:
•Create new database users
•Alter and drop existing database users
•Monitor information about existing users
•Obtain user information
15-3 Copyright © Oracle Corporation, 2002. All rights reserved.
Account
locking
Tablespace
quotas
Temporary
tablespace
Default
tablespace
Role
privileges
Resource
limits
Security
domain
Direct
privileges
Authentication
mechanism
Users and Security
15-4 Copyright © Oracle Corporation, 2002. All rights reserved.
15-5 Copyright © Oracle Corporation, 2002. All rights reserved.
Database Schema
Schema Objects
Tables
Triggers
Constraints
Indexes
Views
Sequences
Stored program units
Synonyms
User-defined data types
Database links
•A schema is a named
collection of objects.
•A user is created, and a
corresponding schema
is created.
•A user can be
associated with only one
schema.
•Username and schema
are often used
interchangeably.
