ORACLE创建用户

 

CREATE TABLESPACE qsh_DATA

DATAFILE 'C:\oracletest\qsh_data01.dbf'

SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED ;

 

CREATE TABLESPACE qsh_INDEX

DATAFILE 'C:\oracletest\qsh_index01.dbf'

SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED ;

 

CREATE TABLESPACE qsh_HIS

DATAFILE 'C:\oracletest\qsh_his01.dbf'

SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED ;

 

CREATE USER qsh IDENTIFIED BY qsh

TEMPORARY TABLESPACE TEMP

DEFAULT TABLESPACE qsh_DATA

QUOTA UNLIMITED ON qsh_DATA

QUOTA UNLIMITED ON qsh_INDEX

QUOTA UNLIMITED ON qsh_HIS; 

 

GRANT CREATE SESSION        TO  qsh;

GRANT ALTER  SESSION        TO  qsh;

GRANT CREATE TABLE          TO  qsh;

GRANT CREATE VIEW           TO  qsh;

GRANT CREATE SYNONYM        TO  qsh;

GRANT CREATE SEQUENCE       TO  qsh;

GRANT CREATE PROCEDURE      TO  qsh;

GRANT CREATE TRIGGER        TO  qsh;

GRANT CREATE TYPE           TO  qsh;

GRANT CREATE DATABASE LINK  TO  qsh;

GRANT DBA  TO  qsh;