----------------------------------------------------
-- Export file for user JSYD                      --
-- Created by Administrator on 2008-9-4, 10:34:43 --
----------------------------------------------------set echo on
--set feedback off
--set verify off

--define tb_path=C:\oracle\product\10.1.0\oradata\steel_trade\

--prompt '建立表空間開始...'

create tablespace STEEL_TRADE_DAT datafile '&tb_path\STEEL_TRADE_DAT.DBF' size 10M AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED extent management local uniform size 128k online;
create tablespace STEEL_TRADE_IDX datafile '&tb_path\STEEL_TRADE_IDX.DBF' size 10M AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED extent management local uniform size 128k online;
create temporary tablespace STEEL_TRADE_TMP tempfile '&tb_path\STEEL_TRADE_TMP.DBF' size 10m AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED extent management local uniform size 128k;

--prompt '建立表空間完畢！'

----------------------------------------------------
-- Export file for user JSYD                      --
-- Created by Administrator on 2008-9-4, 10:34:43 --
----------------------------------------------------
--prompt '創建數據庫用戶...'

--set feedback off
--set define off
--set echo off
--PROMPT 正在創建login ---jsyd
create user bid_admin identified by a123456
    default tablespace STEEL_TRADE_DAT
    temporary tablespace STEEL_TRADE_TMP
    account unlock;

--PROMPT 正在創建角色權限 ---jsyd

--PROMPT 正在創建系統權限 ---jsyd
grant AUDIT ANY to bid_admin with admin option;
grant DROP USER to bid_admin with admin option;
grant ALTER USER to bid_admin with admin option;
grant ANALYZE ANY to bid_admin with admin option;
grant BECOME USER to bid_admin with admin option;
grant CREATE ROLE to bid_admin with admin option;
grant CREATE TYPE to bid_admin with admin option;
grant CREATE USER to bid_admin with admin option;
grant CREATE VIEW to bid_admin with admin option;
grant ALTER SYSTEM to bid_admin with admin option;
grant AUDIT SYSTEM to bid_admin with admin option;
grant CREATE TABLE to bid_admin with admin option;
grant DROP PROFILE to bid_admin with admin option;
grant ALTER PROFILE to bid_admin with admin option;
grant ALTER SESSION to bid_admin with admin option;
grant DROP ANY ROLE to bid_admin with admin option;
grant DROP ANY TYPE to bid_admin with admin option;
grant DROP ANY VIEW to bid_admin with admin option;
grant QUERY REWRITE to bid_admin with admin option;
grant ALTER ANY ROLE to bid_admin with admin option;
grant ALTER ANY TYPE to bid_admin with admin option;
grant ALTER DATABASE to bid_admin with admin option;
grant CREATE CLUSTER to bid_admin with admin option;
grant CREATE LIBRARY to bid_admin with admin option;
grant CREATE PROFILE to bid_admin with admin option;
grant CREATE SESSION to bid_admin with admin option;
grant CREATE SYNONYM to bid_admin with admin option;
grant CREATE TRIGGER to bid_admin with admin option;
grant DROP ANY INDEX to bid_admin with admin option;
grant DROP ANY TABLE to bid_admin with admin option;
grant GRANT ANY ROLE to bid_admin with admin option;
grant LOCK ANY TABLE to bid_admin with admin option;
grant ALTER ANY INDEX to bid_admin with admin option;
grant ALTER ANY TABLE to bid_admin with admin option;
grant CREATE ANY TYPE to bid_admin with admin option;
grant CREATE ANY VIEW to bid_admin with admin option;
grant CREATE SEQUENCE to bid_admin with admin option;
grant CREATE SNAPSHOT to bid_admin with admin option;
grant DROP TABLESPACE to bid_admin with admin option;
grant ALTER TABLESPACE to bid_admin with admin option;
grant BACKUP ANY TABLE to bid_admin with admin option;
grant CREATE ANY INDEX to bid_admin with admin option;
grant CREATE ANY TABLE to bid_admin with admin option;
grant CREATE PROCEDURE to bid_admin with admin option;
grant DELETE ANY TABLE to bid_admin with admin option;
grant DROP ANY CLUSTER to bid_admin with admin option;
grant DROP ANY LIBRARY to bid_admin with admin option;
grant DROP ANY SYNONYM to bid_admin with admin option;
grant DROP ANY TRIGGER to bid_admin with admin option;
grant EXECUTE ANY TYPE to bid_admin with admin option;
grant INSERT ANY TABLE to bid_admin with admin option;
grant SELECT ANY TABLE to bid_admin with admin option;
grant UPDATE ANY TABLE to bid_admin with admin option;
grant ALTER ANY CLUSTER to bid_admin with admin option;
grant ALTER ANY LIBRARY to bid_admin with admin option;
grant ALTER ANY TRIGGER to bid_admin with admin option;
grant COMMENT ANY TABLE to bid_admin with admin option;
grant CREATE TABLESPACE to bid_admin with admin option;
grant DROP ANY SEQUENCE to bid_admin with admin option;
grant DROP ANY SNAPSHOT to bid_admin with admin option;
grant FORCE TRANSACTION to bid_admin with admin option;
grant MANAGE TABLESPACE to bid_admin with admin option;
grant ALTER ANY SEQUENCE to bid_admin with admin option;
grant ALTER ANY SNAPSHOT to bid_admin with admin option;
grant CREATE ANY CLUSTER to bid_admin with admin option;
grant CREATE ANY LIBRARY to bid_admin with admin option;
grant CREATE ANY SYNONYM to bid_admin with admin option;
grant CREATE ANY TRIGGER to bid_admin with admin option;
grant DROP ANY DIRECTORY to bid_admin with admin option;
grant DROP ANY PROCEDURE to bid_admin with admin option;
grant RESTRICTED SESSION to bid_admin with admin option;
grant ALTER ANY PROCEDURE to bid_admin with admin option;
grant ALTER RESOURCE COST to bid_admin with admin option;
grant CREATE ANY SEQUENCE to bid_admin with admin option;
grant CREATE ANY SNAPSHOT to bid_admin with admin option;
grant DROP PUBLIC SYNONYM to bid_admin with admin option;
grant EXECUTE ANY LIBRARY to bid_admin with admin option;
grant GRANT ANY PRIVILEGE to bid_admin with admin option;
grant SELECT ANY SEQUENCE to bid_admin with admin option;
grant CREATE ANY DIRECTORY to bid_admin with admin option;
grant CREATE ANY PROCEDURE to bid_admin with admin option;
grant CREATE DATABASE LINK to bid_admin with admin option;
grant GLOBAL QUERY REWRITE to bid_admin with admin option;
grant UNLIMITED TABLESPACE to bid_admin with admin option;
grant CREATE PUBLIC SYNONYM to bid_admin with admin option;
grant DROP ROLLBACK SEGMENT to bid_admin with admin option;
grant EXECUTE ANY PROCEDURE to bid_admin with admin option;
grant FORCE ANY TRANSACTION to bid_admin with admin option;
grant SELECT ANY DICTIONARY to bid_admin with admin option;
grant ALTER ROLLBACK SEGMENT to bid_admin with admin option;
grant CREATE ROLLBACK SEGMENT to bid_admin with admin option;
grant DROP PUBLIC DATABASE LINK to bid_admin with admin option;
grant CREATE PUBLIC DATABASE LINK to bid_admin with admin option;
--exit;