Oracle中创建用户

记录一下在Oracle中创建用户的全过程。

 

进入“Start --> Oracle - OraDb11g_home1 --> SQL Plus”

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 12 17:24:55 2012 

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter user-name: system
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

创建表空间

SQL>

create tablespace test
datafile 'd:\oracle\oradata\test.dbf' size 50M
default storage (initial 500K

next 500K
minextents 1
maxextents unlimited
pctincrease 0);

Tablespace created.

创建用户

SQL>

create user dding identified by try1now default tablespace test;

User created.

授予用户权限

SQL>

grant resource,connect to dding;

Grant succeeded.

 

SQL>

exit

其他

删除表空间 

drop tablespace "空间名" including contents and datafiles

或

drop user "用户名" cascade

更改表空间

alter tablespace chinawater add datafile 'c:\oracle\oradata\orcl9\ADDCHINAWATER.dbf' size 200M

修改用户密码

create user userName identified by password;

权限相关

grant dba to dding;--授予DBA权限 
grant unlimited tablespace to dding;--授予不限制的表空间 
grant select any table to dding;--授予查询任何表 
grant select any dictionary to dding;

通过 Wiz 发布