创建表空间

  1. create smallfile tablespace "spacename" datafile "spacename.dbf" size 2G autoextend on next 100M logging default nocompress online extent management local autoallocate segment space management auto;

创建用户

  1. create user "username" identified by "password" profile "default" account unlock default tablespace "spacename" temporary tablespace "temp";
  2. grant "connect" to "username";
  3. GRANT RESOURCE TO "username";
  4. GRANT UNLIMITED TABLESPACE TO username;
  5. -- GRANT READ,WRITE ON DIRECTORY "目录对象" TO "username";

访问表空间权限

创建用户时已指定spacename

  1. alter user username quota unlimited on spacename;

初始权限

  1. connect
  2. resource

授权

  1. grant 权限 to username;

取消授权

  1. revoke 权限 from username;

锁和解锁用户

  1. alter user username account lock;
  2. alter user username account unlock;