linux 下如何创建oracle 新用户

在CRT中进入oracle

--连接sqlplus

按照下面写完代码直接复制进去回车就行了

---建立用户代码为：CREATE

USER

"用户名字"

PROFILE

"DEFAULT"

IDENTIFIED

BY

"密码"

DEFAULT

TABLESPACE

"指定表空间名字"

TEMPORARY

TABLESPACE

"临时表空间"

ACCOUNT

UNLOCK

---赋权

begin

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

DICTIONARY

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

ALTER

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

ALTER

SYSTEM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

ALTER

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CONNECT

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

INDEX

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

DATABASE

LINK

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

PUBLIC

DATABASE

LINK

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

VIEW

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

PUBLIC

SYNONYM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DELETE

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

PUBLIC

DATABASE

LINK

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

TRIGGER

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

INDEX

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

VIEW

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

PUBLIC

SYNONYM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

PUBLIC

SYNONYM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

SEQUENCE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

EXECUTE

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

GRANT

ANY

PRIVILEGE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

GRANT

ANY

ROLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

TRIGGER

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

INSERT

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

DICTIONARY

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

SEQUENCE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

SEQUENCE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

UNLIMITED

TABLESPACE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

UPDATE

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

COMMENT

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

TYPE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

TABLESPACE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

USER

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

EXP_FULL_DATABASE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

IMP_FULL_DATABASE

TO

用户名'

End

---或者直接给DBA权限

先su 到 oracle用户，SYS用户以DBA身份登陆

//创建临时表空间

SQL>create temporary tablespace user_temp

datafile '/data1/oradata/user_temp.dbf'

size 5000M autoextend on

//创建数据表空间

SQL>create tablespace user_temp

datafile '/data1/oradata/user_temp.dbf'

size 500M autoextend on

（这些只是例子，具体数据文件的路径，大小，都要你自己改，这里的是不自动扩展，你如果想自动扩展，autoextend on next 50m maxsize 2048m，上网查一下就可以了）

//创建用户并指定表空间

SQL>create user username identified by password

default tablespace user_data

temporary tablespace user_temp

//给用户授予权限

SQL>grant connect,resource to username

在CRT中进入oracle --连接sqlplus 按照下面写完代码直接复制进去回车就行了

---建立用户代码为：CREATE USER "用户名字" PROFILE "DEFAULT" IDENTIFIED BY "密码" DEFAULT TABLESPACE "指定表空间名字" TEMPORARY TABLESPACE "临时表空间" ACCOUNT UNLOCK

---赋权

begin

EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO 用户名'

EXECUTE IMMEDIATE 'GRANT ALTER ANY TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT ALTER SYSTEM TO 用户名'

EXECUTE IMMEDIATE 'GRANT ALTER ANY PROCEDURE TO 用户名'

EXECUTE IMMEDIATE 'GRANT CONNECT TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE ANY PROCEDURE TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE ANY TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE ANY INDEX TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE DATABASE LINK TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC DATABASE LINK TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE ANY VIEW TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC SYNONYM TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT DELETE ANY TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP PUBLIC DATABASE LINK TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP ANY TRIGGER TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP ANY INDEX TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP ANY PROCEDURE TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP ANY TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP ANY VIEW TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC SYNONYM TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP PUBLIC SYNONYM TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE ANY SEQUENCE TO 用户名'

EXECUTE IMMEDIATE 'GRANT EXECUTE ANY PROCEDURE TO 用户名'

EXECUTE IMMEDIATE 'GRANT GRANT ANY PRIVILEGE TO 用户名'

EXECUTE IMMEDIATE 'GRANT GRANT ANY ROLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT CREATE ANY TRIGGER TO 用户名'

EXECUTE IMMEDIATE 'GRANT INSERT ANY TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO 用户名'

EXECUTE IMMEDIATE 'GRANT SELECT ANY SEQUENCE TO 用户名'

EXECUTE IMMEDIATE 'GRANT DROP ANY SEQUENCE TO 用户名'

EXECUTE IMMEDIATE 'GRANT SELECT ANY TABLE TO 用户名'

EXECUTE IMMEDIATE 'GRANT UNLIMITED TABLESPACE TO 用户名'

---