Oracle 9i - User Management and Database Security.pdf

(1301 KB) Pobierz
Revision no.: PPT/2K403/02
User Management and Database Security
Revision no.: PPT/2K403/02
Oracle database security management
2
•
•
•
•
•
Controlling access to data ( authorization )
Authenticating users
Ensuring data integrity
Auditing user’s actions
Managing enterprise security
© CMS INSTITUTE, 2004.
All rights reserved. No part of this material may be reproduced, stored or emailed without the prior permission of Programme Director, CMS Institute
Revision no.: PPT/2K403/02
Managing Users
3
•
•
•
Creating new database users
Altering and dropping existing database users
Monitoring information about existing users
© CMS INSTITUTE, 2004.
All rights reserved. No part of this material may be reproduced, stored or emailed without the prior permission of Programme Director, CMS Institute
Revision no.: PPT/2K403/02
Users and Security
4
Account
locking
Default
tablespace
•
DBA defines users who
can access db
Authentication
mechanism
Temporary
tablespace
•
Security domain
defines the settings
that apply to users
Role
privileges
Security
domain
Tablespace
quotas
Resource
limits
Direct
privileges
© CMS INSTITUTE, 2004.
All rights reserved. No part of this material may be reproduced, stored or emailed without the prior permission of Programme Director, CMS Institute
Revision no.: PPT/2K403/02
Database Schema
5
•
Schema: named collection of objects like tables, views,
procedures, etc.
•
•
•
When a user is created a schema with same name is created
Hence username and schema name used interchangeably
Some of the objects a user can own
© CMS INSTITUTE, 2004.
All rights reserved. No part of this material may be reproduced, stored or emailed without the prior permission of Programme Director, CMS Institute

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin