Properties

Name:	OLAPSYS
Password required:
Status:	EXPIRED & LOCKED
Default tablespace:	CWMLITE
Temporary tablespace:	TEMP
Profile:	DEFAULT
lock_date:	11/18/2004
expire_date:	11/18/2004
Consumer group:	DEFAULT_CONSUMER_GROUP
External name:

Grants

Admin	Default role	Grantee
NO	YES	OLAPSYS
NO	YES	OLAPSYS
NO	YES	OLAPSYS

Total: 3 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 LIBRARY	OLAPSYS	NO
	CREATE PROCEDURE	OLAPSYS	NO
	CREATE PUBLIC SYNONYM	OLAPSYS	NO
	CREATE SEQUENCE	OLAPSYS	NO
	CREATE TABLE	OLAPSYS	NO
	CREATE VIEW	OLAPSYS	NO
	DROP PUBLIC SYNONYM	OLAPSYS	NO
	SELECT ANY TABLE	OLAPSYS	NO
	UNLIMITED TABLESPACE	OLAPSYS	NO
	ALTER ANY DIMENSION	OLAP_DBA	NO
	ALTER ANY TABLE	OLAP_DBA	NO
	ANALYZE ANY	OLAP_DBA	NO
	CREATE ANY DIMENSION	OLAP_DBA	NO
	CREATE ANY INDEX	OLAP_DBA	NO
	CREATE ANY TABLE	OLAP_DBA	NO
	CREATE ANY VIEW	OLAP_DBA	NO
	DROP ANY DIMENSION	OLAP_DBA	NO
	DROP ANY TABLE	OLAP_DBA	NO
	DROP ANY VIEW	OLAP_DBA	NO
	LOCK ANY TABLE	OLAP_DBA	NO
	SELECT ANY DICTIONARY	OLAP_DBA	NO
	SELECT ANY TABLE	OLAP_DBA	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

Total: 38 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)

Quotas

	Tablespace	Quota,KB	UsedSpace,KB	% Used
	CWMLITE	Unlimited	9536	0

Total: 1 quota(s)

DDL

   CREATE USER "OLAPSYS" IDENTIFIED BY VALUES '3FB8EF9DB538647C'
      DEFAULT TABLESPACE "CWMLITE"
      TEMPORARY TABLESPACE "TEMP"
      PASSWORD EXPIRE
      ACCOUNT LOCK

See Also

List of users