C:/Documents and Settings/Administrator>cd c:/oraclexe
C:/oraclexe>cd apex
C:/oraclexe/apex>sqlplus /nolog;
C:/oraclexe/apex>sqlplus /nolog
SQL*Plus: Release 10.2.0 .1.0 - Production on 星期二 10月 21 21:10:35 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba;
已连接。
SQL> @ apxldimg.sql C:/oraclexe;
PL/SQL 过程已成功完成。
原值 1: create directory APEX_IMAGES as '&1/apex/images'
新值 1: create directory APEX_IMAGES as 'C:/oraclexe/apex/images'
目录已创建。
PL/SQL 过程已成功完成。
PL/SQL 过程已成功完成。
提交完成。
计时: Load Images
已用时间: 00: 02: 00.68
目录已删除。
SQL> define ta_user = school
SQL>
SQL> -- DROP USER &ta_user CASCADE;
SQL>
SQL> CREATE USER &ta_user IDENTIFIED BY admin;
原值 1: CREATE USER &ta_user IDENTIFIED BY admin
新值 1: CREATE USER school IDENTIFIED BY admin
用户已创建。
SQL>
SQL> GRANT connect,resource TO &ta_user;
原值 1: GRANT connect,resource TO &ta_user
新值 1: GRANT connect,resource TO school
授权成功。
SQL>
SQL> GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO &ta_user;
原值 1: GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO &ta_user
新值 1: GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO school
授权成功。
SQL>
SQL> GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO &ta_user;
原值 1: GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO &ta_user
新值 1: GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO school
授权成功。
SQL>
SQL> GRANT CREATE ROLE, CREATE SEQUENCE TO &ta_user;
原值 1: GRANT CREATE ROLE, CREATE SEQUENCE TO &ta_user
新值 1: GRANT CREATE ROLE, CREATE SEQUENCE TO school
授权成功。
SQL>
SQL> GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIE
W TO &ta_user;
原值 1: GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREA
TE VIEW TO &ta_user
新值 1: GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREA
TE VIEW TO school
授权成功。
SQL>