plsql中创建/删除表空间和新用户并授权

—创建表空间
create tablespace “BZCC”
logging
datafile ‘/home/oracle/BZCC.dbf’ size 300m autoextend
on next 10m maxsize unlimited

—创建新用户
create user ccbzk262 identified by Caifu123
default tablespace “BZCC”
temporary tablespace temp
profile default;

—创建授权
grant connect,resource to ccbzk262;
grant create any directory to ccbzk262;
grant create database link to ccbzk262;
grant create table to ccbzk262;
grant create view to ccbzk262;
grant unlimited tablespace to ccbzk262;
grant dba to ccbzk262;

删除用户及表空间
select t.default_tablespace,t.* from dba_users t ;

drop user CCBZKbd cascade;