Backup and Recovery Overview

作者: David, 于 October 20th,2008

1.Categories of Failures
.Statement failure
.User process failure
.user error
.Instance failure
.Media failure
.Network failure

October 20th, 2008 | Tags: , | Category: Oracle RDBMS | 留言

Managing User

作者: David, 于 October 20th,2008

1.Security Domain
Authentication Mechanism
. Data Dictionary
. Operating system
. Network

Syntax
Use the following command to create a new user:

?View Code SQL1
2
3
4
5
6
7
8
9
10
CREATE USER user
IDENTIFIED {BY password | EXTERNALLY}
[ DEFAULT TABLESPACE tablespace ]
[ TEMPORARY TABLESPACE tablespace ]
[ QUOTA {integer [K | M ] | UNLIMITED } ON tablespace
[ QUOTA {integer [K | M ] | UNLIMITED } ON tablespace
]…]
[ PASSWORD [...]

October 20th, 2008 | Tags: | Category: Oracle RDBMS | 留言

Managing Privileges

作者: David, 于 October 20th,2008

1.Two Types of Oracle user privileges

?View Code TEXT1
2
3
4
5
6
7
8
. System privilege:Enables users to perform particular actions in the database
. Object:Enables users to access and manipulate a specific object
. There is no CREATE INDEX privilege.
. CREATE TABLE includes the CREATE INDEX and the ANALYZE commands. The user
must have a quota for the tablespace or must [...]

October 20th, 2008 | Tags: | Category: Oracle RDBMS | 留言