Properties

Name: SCOTT 
Password required:  
Status: LOCKED 
Default tablespace: SYSTEM 
Temporary tablespace: TEMP 
Profile: DEFAULT 
lock_date: 12/26/2004 
expire_date:  
Consumer group: DEFAULT_CONSUMER_GROUP 
External name:  

Grants

Admin Default role Grantee
NO  YES  SCOTT 
NO  YES  SCOTT 
Total: 2 grant(s)

Privilages

Name Grantee Admin
  ALTER SESSION  CONNECT  NO 
  CREATE CLUSTER  CONNECT  NO 
  CREATE DATABASE LINK  CONNECT  NO 
  CREATE SEQUENCE  CONNECT  NO 
  CREATE SESSION  CONNECT  NO 
  CREATE SYNONYM  CONNECT  NO 
  CREATE TABLE  CONNECT  NO 
  CREATE VIEW  CONNECT  NO 
  CREATE CLUSTER  RESOURCE  NO 
  CREATE INDEXTYPE  RESOURCE  NO 
  CREATE OPERATOR  RESOURCE  NO 
  CREATE PROCEDURE  RESOURCE  NO 
  CREATE SEQUENCE  RESOURCE  NO 
  CREATE TABLE  RESOURCE  NO 
  CREATE TRIGGER  RESOURCE  NO 
  CREATE TYPE  RESOURCE  NO 
  UNLIMITED TABLESPACE  SCOTT  NO 
Total: 17 privilage(s)

Resource groups

Name Grant option Initial group Grantee
  DEFAULT_CONSUMER_GROUP  YES  YES  PUBLIC 
  LOW_GROUP  NO  NO  PUBLIC 
Total: 2 resource group(s)

DDL


   CREATE USER "SCOTT" IDENTIFIED BY VALUES 'F894844C34402B67'
      TEMPORARY TABLESPACE "TEMP"
      ACCOUNT LOCK

See Also

List of users