3,491
社区成员
发帖
与我相关
我的任务
分享
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;