补充说明:用sys用户登陆 新建“command window”窗口(File>New>Command Window)执行语句。-- 建立新用户test (用sys用户登陆 新建“command window”窗口(File>New>Command Window)执行语句)create user icd identified by test default tablespace test_service temporary tablespace test_TEMP / grant dba to test with admin option / grant execute on sys.dbms_sys_sql to test with grant option / grant unlimited tablespace to test / GRANT SELECT ON SYS.DBA_JOBS TO test with grant option /
create tablespace test_service
datafile 'E:\oracle\oradata\ora92\test_service01.dbf' size 100M REUSE
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M--oracle 安装在aix系统 建立表空间语句create tablespace test_service
datafile '/dev/rdata01' size 100M reuse
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/
grant dba to test with admin option
/
grant execute on sys.dbms_sys_sql to test with grant option
/
grant unlimited tablespace to test
/
GRANT SELECT ON SYS.DBA_JOBS TO test with grant option
/