–创建用户 创建公共用户已c##开头
create user c##focus identified by FocusBI DEFAULT TABLESPACE USERS;
–account unlock;
–授权
grant connect,resource to c##focus; --授予 connect resource 权限
grant create table to connect; --授予 创建表权限
GRANT CREATE TABLE TO c##focus;
GRANT UNLIMITED TABLESPACE TO USERS;
GRANT CREATE SESSION TO USERS;
GRANT CREATE TABLE,CREATE VIEW,CREATE TRIGGER, CREATE SEQUENCE,CREATE PROCEDURE TO c##focus;
GRANT DBA TO c##focus;
SELECT tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;
–删除用户
drop user c##focus cascade;
–删除表空间
drop tablespace c##focus including contents and datafiles cascade constraints;