--修改用户,授权并与表空间关联
CREATE TABLESPACE CONFLUENCE
LOGGING
DATAFILE 'D:\app\oracle\oradata\depmng\confluence\CONFLUENCE01.dbf'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
-- USER SQL
alter USER confluence
DEFAULT TABLESPACE "CONFLUENCE"
TEMPORARY TABLESPACE "TEMP";
-- QUOTAS
ALTER USER confluence QUOTA UNLIMITED ON CONFLUENCE;
-- ROLES
GRANT "DBA" TO confluence ;
-- SYSTEM PRIVILEGES
CREATE TABLESPACE CONFLUENCE
LOGGING
DATAFILE 'D:\app\oracle\oradata\depmng\confluence\CONFLUENCE01.dbf'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
-- USER SQL
alter USER confluence
DEFAULT TABLESPACE "CONFLUENCE"
TEMPORARY TABLESPACE "TEMP";
-- QUOTAS
ALTER USER confluence QUOTA UNLIMITED ON CONFLUENCE;
-- ROLES
GRANT "DBA" TO confluence ;
-- SYSTEM PRIVILEGES