. 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 have been granted UNLIMITE TABLESPACE.
. Privileges such as CREATE TABLE, CREATE PROCEDURE, or CREATE CLUSTER include the dropping of these objects.
. UNLIMITED TABLESPACE cannot be granted to a role.
. For truncating a table in another schema, the DROP ANY TABLE privilege is necessary.
1.Categories of Failures
.Statement failure
.User process failure
.user error
.Instance failure
.Media failure
.Network failure
More…
Popularity: 33% [?]
1.Security Domain
Authentication Mechanism
. Data Dictionary
. Operating system
. Network
Syntax
Use the following command to create a new user:
More…
Popularity: 29% [?]
1.Two Types of Oracle user privileges
More…
Popularity: 26% [?]