Warehouse Libraries - lib_util_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: lib_util_h.sql -- -- Author: Steve Roach -- -- Date: 15-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating to -- -- LIB_UTIL. -- -- -- -- Procedures: -- -- ------------------------------------------------------------------------ -- -- Procedure: create_synonyms -- -- -- -- Creates synonyms to tables, views and sequences owned by other -- -- users, excluding system objects. -- -- ------------------------------------------------------------------------- -- -- Procedure: create_grants -- -- -- -- Revokes and creates grants to all users for tables, views, -- -- sequences and packages owned by user. -- -- ------------------------------------------------------------------------- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 15-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE lib_util AS PROCEDURE create_synonyms; PROCEDURE create_grants; END lib_util; / SHOW ERRORS