October 2008
M T W T F S S
« Sep   Nov »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Backup and Recovery Overview

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

Managing User

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 [...]

Managing Privileges

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 [...]