oracle 用户权限-CSDN博客

oracle用户创建和权限的管理
-------------------------------------------------------
create user user_name identified by user_pass default tablespace tab_1;
grant connect,resource to user_name;
revoke connect from user_name;
------------本用户创建表空间---
alter user user_name default tablespace tab_1;
-------------------------------------------------
create tablespace tablespace1 datafile 'd:a.dbf' size 10m auto extend on next 10m;

alter database datafile 'F:ORACLEPRODUCT10.2.0ORADATATESTPCS.DBF' autoextend on next 10m maxsize unlimited;

------更改用户默认表空间---------------------------

alter user user_name default tablespace tab_1;

---------------用户拥有使用表空间的权限--------

grant unlimited tablespace to 用户名;

--赋权-execute immediate create table 权限
grant create any table to pcs;

1.增加数据文件
ALTER TABLESPACE game
ADD DATAFILE '/oracle/oradata/db/GAME02.dbf' SIZE 1000M;

2.手动增加数据文件尺寸
ALTER DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf'
RESIZE 4000M;

3.设定数据文件自动扩展
ALTER DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf AUTOEXTEND ON NEXT 100M MAXSIZE 10000M;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9307930/viewspace-1028707/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9307930/viewspace-1028707/