-- Sample code!
-- Steve Friedberg, 2015/05/07
-- Run this as sys. Possible syntax:
-- [OS] sqlplus sys / as sysdba @create_oemm_admin.sql
-- Optionally make a global change of "oemmadmn" to a user name of your choice.

-- Change the password "Welcome1" to something of your choosing:
create user oemmadmn identified by Welcome1;
set echo on;
grant EXECUTE on CTXSYS.CTX_DDL to oemmadmn;
grant EXECUTE on SYS.DBMS_LOCK to oemmadmn;
-- You might want to throttle back the "unlimited"...
alter user oemmadmn QUOTA unlimited on USERS;

grant CREATE SESSION to oemmadmn;
grant CREATE PROCEDURE to oemmadmn;
grant CREATE SEQUENCE to oemmadmn;
grant CREATE TABLE to oemmadmn;
grant CREATE TRIGGER to oemmadmn;
grant CREATE TYPE to oemmadmn;
grant CREATE VIEW to oemmadmn;
-- Or for Proof of Concept, you could simply "grant dba to oemmadmn;" ...