Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\md\admin\sdowfspv.sql

Rem
Rem $Header: sdo/admin/sdowfspv.sql /main/7 2008/12/23 16:09:23 sravada Exp $
Rem
Rem sdowfspv.sql
Rem
Rem Copyright (c) 2005, 2008, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      sdowfspv.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    sravada     12/23/08 - bug 7659056
Rem    ningan      10/23/08 - fix bug 7475076
Rem    rchatter    12/28/05 - add wfs admin user 
Rem    rchatter    12/28/05 - Created
Rem

alter session set current_schema=sys;

declare
  stmt VARCHAR2(10000);
begin  
    stmt := ' CREATE role spatial_wfs_admin identified by spatial_wfs_admin ';
    execute immediate stmt; 
    exception when others then null;
end;                          
/

-- bug7475076
declare
  stmt VARCHAR2(10000);
begin
    stmt := 'ALTER ROLE spatial_wfs_admin NOT IDENTIFIED';
    execute immediate stmt;
    exception when others then null;
end;
/

declare
  stmt VARCHAR2(10000);
  rec_count NUMBER;
begin  
  select count(*) into rec_count from DBA_USERS where USERNAME = 'SPATIAL_WFS_ADMIN_USR' ;
  if(rec_count = 0) then
    stmt := ' CREATE USER spatial_wfs_admin_usr IDENTIFIED BY spatial_wfs_admin_usr ';
    execute immediate stmt; 
  else 
     stmt := ' drop user spatial_wfs_admin_usr cascade ';
     execute immediate stmt;
     stmt := ' CREATE USER spatial_wfs_admin_usr IDENTIFIED BY spatial_wfs_admin_usr ';
     execute immediate stmt; 
  end if;
end;                          
/

-- drop user spatial_wfs_admin_usr cascade;
-- the password for spatial_wfs_admin_usr can be set by the user after installation 
-- CREATE USER spatial_wfs_admin_usr IDENTIFIED BY spatial_wfs_admin_usr;

GRANT CONNECT, RESOURCE, CREATE LIBRARY, create procedure  TO spatial_wfs_admin_usr;
GRANT CREATE ANY DIRECTORY TO spatial_wfs_admin_usr;
GRANT create role, alter any role, drop any role, grant any role TO spatial_wfs_admin_usr;
grant spatial_wfs_admin to spatial_wfs_admin_usr with admin option;
alter user spatial_wfs_admin_usr account lock password expire;

declare
  stmt VARCHAR2(10000);
begin
    stmt := ' CREATE role  wfs_usr_role identified by wfs_usr_role ';
    execute immediate stmt;
    exception when others then null;
end;
/

-- drop role wfs_usr_role;
-- create role wfs_usr_role identified by wfs_usr_role;

alter session set current_schema=mdsys;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de