PACKAGE: APPS.APPS_DDL

Source

1 package APPS_DDL AUTHID DEFINER as
2 /* $Header: adaddls.pls 115.1 99/07/17 04:29:35 porting ship $ */
3    --
4    -- Package
5    --   APPS_DDL
6    -- Purpose
7    --   Dynamic DDL support
8    -- Notes
9    --   1. This package is created in each Oracle Applications account
10    --   2. Each account requires the following explicit
11    --      privileges to run (i.e. these privileges cannot be obtained
12    --      from a role, like 'connect'):
13    --		grant create session to <schema>
14    --		grant alter session to <schema>
15    --		grant create database link to <schema>
16    --		grant create synonym to <schema>
17    --		grant create view to <schema>
18    --		grant create cluster to <schema>
19    --		grant create procedure to <schema>
20    --		grant create sequence to <schema>
21    --		grant create table to <schema>
22    --		grant create trigger to <schema>
23    --	Currently AutoInstall grants the neccessary privs to each schema
24    --
25 procedure apps_ddl(ddl_text in varchar2);
26 end APPS_DDL;