oracle创建用户和权限,Oracle创建用户和权限管理

Oracle创建表空间：

create tablespace iam20141015

datafile '/u01/oracle/oradata/iam3/iam20141015.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

创建临时表空间：

create temporary tablespace iam20141015_tmp

tempfile '/u01/oracle/oradata/iam3/iam20141015_tmp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

创建用户并指定表空间：

create user iam20141015 identified by iam20141015

default tablespace iam20141015 temporary tablespace iam20141015_tmp

account unlock;

给用户授权：

grant create session, create any table, create any view, create any index, create any procedure, alter any table, alter any procedure, drop any table, drop any view, drop any index, drop any procedure, select any table, insert any table, update any table, delete any table to iam20141015;

grant create session to iam20141015;

grant connect to iam20141015;

grant resource to iam20141015;

grant dba to iam20141015;

Oracle权限管理

--用户相关权限

create user

alter user

drop user

--表权限

select any table

update any table

delete any table

create any table

drop any table

alter any table

create create

--表空间权限

create tablespace

drop tablespace

alter tablespace

unlimited tablespace(全部表空间权限)

--索引权限

create any index

drop any index

alter any index

--会话权限

create session

later session

--其他系统对象权限

create view

create sequence

create procedure