--查看表空间
select * from dba_data_files;
1.创建表空间
create tablespace test_ts datafile '/data/test/test_ts_30g.dbf' size 10000M autoextend on next 1000M maxsize 30g extent management local;
2.创建用户
create user test identified by 123456 default tablespace test_ts temporary tablespace TEMP profile DEFAULT ;
3.授权
--查询有哪些directory
select * from dba_directories
grant read,write on directory dump_dir to test;
grant connect to test;
grant resource to test;
grant debug connect session to test;
grant unlimited tablespace to test;
grant create synonym to test;
grant create public database link to test;
grant create view to test;
grant create database link to test;
grant create public synonym to test;
grant create synonym to test;
GRANT CREATE SEQUENCE TO test;
GRANT DEBUG any PROCEDURE TO test;
grant exp_full_database to test;
grant imp_full_database to test;
grant read on directory DUMP_DIR to test;
Oracle 创建用户
最新推荐文章于 2024-04-24 11:19:00 发布