Loading...
Archive for October, 2008
  1. 1.Categories of Failures
    .Statement failure
    .User process failure
    .user error
    .Instance failure
    .Media failure
    .Network failure
    More…

    Popularity: 33% [?]

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

    Syntax
    Use the following command to create a new user:

    1
    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 EXPIRE ]
    [ ACCOUNT { LOCK | UNLOCK }]
    [ PROFILE { profile | DEFAULT }]

    More…

    Popularity: 29% [?]

  3. 1.Two Types of Oracle user privileges

    1
    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 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.

    More…

    Popularity: 26% [?]

Powered by ExtJS Theme flavored Wordpress.