oracle flows files,oracle用户权限管理

SQL> drop user t1 cascade;删除用户及相关东西

create user anqing identified by anqing (default tablespace

users/temporary tablespace temp) quota 10M on

users;创建用户的过程中指定配额空间和指定表空间

create user t1 identified by t1 default tablespace t1 quota

unlimited on t1;

创建T1用户密码T1 默认表空间T1 配额无限在T1；

User created.

SQL> create user t2 identified by t2 default

tablespace t1;

SQL> grant create session to t2;

Grant succeeded.

SQL> grant create table to t2;

Grant succeeded.

SQL> select * from user_sys_privs;

USERNAME PRIVILEGE ADM

------------------------------

---------------------------------------- ---

T2 CREATE

SESSION NO

T2 CREATE

TABLE NO

conn t2/t2;

SQL> create table t2 (id int,name varchar2(10),sal

number(9));

Table created.

SQL> insert into t2 values(1,'suns',777);

insert into t2 values(1,'suns',777)

*

ERROR at line 1:

ORA-01950: no privileges on tablespace 'T1'

用户表空间配额不足。有点奇怪，不过还是先解决问题，解决问题有三种方法：

方法一：SQL> alter user user_name quota unlimited on

tablespace_name;

方法二：SQL> alter user user_name quota 100M on

tablespace_name;

方法三：SQL> grant unlimited tablespace to

user_name;

SQL> alter user t2 quota unlimited on t1;

User altered.

SQL> conn t2/t2;

SQL> insert into t2 values(1,'suns',777);

1 row created.

SQL> select username, tablespace_name,bytes/1024

as M, max_bytes from dba_ts_quotas;

USERNAME TABLESPACE_NAME M MAX_BYTES

------------------------------ ------------------------------

---------- ----------

FLOWS_FILES SYSAUX 0 -1

SYSMAN SYSAUX 65408 -1

OLAPSYS SYSAUX 7488 -1

T2