CREATE TABLESPACE xzfw LOGGING
DATAFILE 'C:/oracle/product/10.2.0/oradata/XZFW/xzfw' SIZE 200M AUTOEXTEND ON NEXT 50M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
-- Create the user
create user XZFW
identified by "xzfw"
default tablespace xzfw
temporary tablespace TEMP
profile DEFAULT
quota unlimited on users;
-- Grant/Revoke role privileges
grant aq_administrator_role to XZFW;
grant aq_user_role to XZFW;
grant authenticateduser to XZFW;
grant connect to XZFW;
grant DBA to XZFW;