1.Categories of Failures
.Statement failure
.User process failure
.user error
.Instance failure
.Media failure
.Network failure
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 [...]
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 [...]
Recent Comments