orcal创建用户、表空间、授权

– 查询数据库表空间储存位置
select * from dba_data_files

–表空间
CREATE TABLESPACE LOANAUDIT
DATAFILE ‘F:\ORACLE\ORADATA\ORCL\LOANAUDIT’ size 800M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

–2.建用户
create user LOANAUDIT identified by LOANAUDIT
default tablespace LOANAUDIT;

–3.赋权
grant connect,resource to LOANAUDIT;
grant create any sequence to LOANAUDIT;
grant create any table to LOANAUDIT;
grant delete any table to LOANAUDIT;
grant insert any table to LOANAUDIT;
grant select any table to LOANAUDIT;
grant unlimited tablespace to LOANAUDIT;
grant execute any procedure to LOANAUDIT;
grant update any table to LOANAUDIT;
grant create any view to LOANAUDIT;