/* Copyright (c) 1996 by the Oracle Corporation */

/* -------------------------------------------------------------------- 
** NAME         POLVUDRP.SQL - SQL script to drop the Oracle7-style data        
**              dictionary views created by polvubld.sql for use by the 
**		Oracle Developer tools on Oracle Lite 3.0 or above database.                
**                                                                      
** MODIFIED  
**   09-JUN-98  cbarrow 	Adapted for OLite 3.0 and above
**   13-AUG-96	cbarrow		Polvudrp.sql created (from rdbvudrp.sql)
** -------------------------------------------------------------------- */

/*
** To use, you may use SQL*Plus as follows:
**
**    plus80.exe system/manager@odbc:polite @polvudrp.sql 
** 
** where system is the user and polite is the odbc datasource
**
*/

SPOOL POLVUDRP.LOG

/* Drop public synonyms */

DROP PUBLIC SYNONYM USER_USERS;
DROP PUBLIC SYNONYM USER_SYNONYMS;
DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE;
DROP PUBLIC SYNONYM ROLE_SYS_PRIVS; 
DROP PUBLIC SYNONYM USER_SYS_PRIVS;
DROP PUBLIC SYNONYM TOOL_MODULE;
DROP PUBLIC SYNONYM ALL_TRIGGERS;

/* Drop views */

DROP VIEW USER_SYNONYMS;
DROP VIEW USER_USERS;   
DROP VIEW PRODUCT_USER_PROFILE;
DROP VIEW ROLE_SYS_PRIVS; 
DROP VIEW USER_SYS_PRIVS;
DROP VIEW TOOL_MODULE;
DROP VIEW ALL_TRIGGERS;

commit;

SPOOL OFF
