Kevin Yeandel’s Random Access Memory

After running the uninstaller clean up the schema. Useful in cases of migration when sysadmin’s password can’t be legally extracted from the Oracle dba and you need to crack on.

set heading off
set feedback off
spool dropobj_x.sql
select ‘drop ‘||object_type||’ ‘||object_name||’ ;’
from user_objects
where object_type <> ‘INDEX’
and object_type <> ‘DATABASE LINK’
and object_type <> ‘PACKAGE BODY’
and object_type <> ‘TRIGGER’
and object_type <> ‘LOB’
order by created;
spool off
set heading on
set feedback on

If you have to have your schema created for you by the hosting company then this is what is required.
Make sure to ask the developers if any triggers will be required as you may wish to add this at the same time.

Schema Parameters        (Tried, tested and in use)
GRANT ALTER SESSION TO xy_resource;
GRANT CREATE DATABASE LINK TO xy_resource;
GRANT CREATE INDEXTYPE TO xy_resource;
GRANT CREATE OPERATOR TO xy_resource;
GRANT CREATE PROCEDURE TO xy_resource;
GRANT CREATE PUBLIC SYNONYM TO xy_resource;
GRANT CREATE ROLE TO xy_resource;
GRANT CREATE SEQUENCE TO xy_resource;
GRANT CREATE SESSION TO xy_resource;
GRANT CREATE SYNONYM TO xy_resource;
GRANT CREATE TABLE TO xy_resource;
GRANT CREATE TYPE TO xy_resource;
GRANT CREATE VIEW TO xy_resource;
GRANT SELECT_CATALOG_ROLE TO xy_resource;