-- Create the user
create user ADMIN
default tablespace SYSTEM
temporary tablespace TEMP
profile DEFAULT
password expire;
-- Grant/Revoke role privileges
grant connect to ADMIN;
grant dba to ADMIN;
grant resource to ADMIN;
-- Grant/Revoke system privileges
grant create table to ADMIN with admin option;
grant unlimited tablespace to ADMIN;
oracl 创建用户
浙公网安备 33010602011771号