全部博文
-
编辑 删除
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 suc
