17,377
社区成员
发帖
与我相关
我的任务
分享
create tablespace demo datafile 'D:\oracle\product\10.2.0\oradata\orcl\demo.dbf' size 100m autoextend on next 10m;
create user demo identified by demo default tablespace demo ;
grant dba to demo;
grant all on dual to appsys with grant option;
-- Create the user
create user ITOM
default tablespace ITOM
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on DUAL to ITOM with grant option;
-- Grant/Revoke role privileges
grant connect to ITOM with admin option;
grant resource to ITOM with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to ITOM with admin option;
SQL> show user;
USER 为 "SYS"
SQL> create user demo identified by demo;
用户已创建。
SQL> grant dba to demo;
授权成功。
SQL> conn demo/demo
已连接。
SQL>