plgaccess.sql

Oracle PL/SQL procedure generator (second generator type)

REM Generated by genaccess.sql DO NOT MODIFY                                    
REM                                                                             
GRANT EXECUTE ON plgdoir TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgdoir;                                                    
CREATE PUBLIC SYNONYM plgdoir FOR plgdoir;                                      
GRANT EXECUTE ON plggen TO PUBLIC;                                              
DROP PUBLIC SYNONYM plggen;                                                     
CREATE PUBLIC SYNONYM plggen FOR plggen;                                        
GRANT EXECUTE ON plggenv TO PUBLIC;                                             
DROP PUBLIC SYNONYM plggenv;                                                    
CREATE PUBLIC SYNONYM plggenv FOR plggenv;                                      
GRANT EXECUTE ON plgte TO PUBLIC;                                               
DROP PUBLIC SYNONYM plgte;                                                      
CREATE PUBLIC SYNONYM plgte FOR plgte;                                          
GRANT EXECUTE ON plgval TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgval;                                                     
CREATE PUBLIC SYNONYM plgval FOR plgval;                                        
GRANT EXECUTE ON plgpriv TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgpriv;                                                    
CREATE PUBLIC SYNONYM plgpriv FOR plgpriv;                                      
GRANT EXECUTE ON plgerr TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgerr;                                                     
CREATE PUBLIC SYNONYM plgerr FOR plgerr;                                        
GRANT EXECUTE ON plgdesc TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgdesc;                                                    
CREATE PUBLIC SYNONYM plgdesc FOR plgdesc;                                      
GRANT EXECUTE ON plgadmin TO PUBLIC;                                            
DROP PUBLIC SYNONYM plgadmin;                                                   
CREATE PUBLIC SYNONYM plgadmin FOR plgadmin;                                    
GRANT EXECUTE ON plgdrv TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgdrv;                                                     
CREATE PUBLIC SYNONYM plgdrv FOR plgdrv;                                        
GRANT EXECUTE ON plgcols TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgcols;                                                    
CREATE PUBLIC SYNONYM plgcols FOR plgcols;                                      
GRANT EXECUTE ON plgcons TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgcons;                                                    
CREATE PUBLIC SYNONYM plgcons FOR plgcons;                                      
GRANT EXECUTE ON plgbool TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgbool;                                                    
CREATE PUBLIC SYNONYM plgbool FOR plgbool;                                      
GRANT EXECUTE ON plgfkys TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgfkys;                                                    
CREATE PUBLIC SYNONYM plgfkys FOR plgfkys;                                      
GRANT EXECUTE ON plginds TO PUBLIC;                                             
DROP PUBLIC SYNONYM plginds;                                                    
CREATE PUBLIC SYNONYM plginds FOR plginds;                                      
GRANT EXECUTE ON plgiseg TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgiseg;                                                    
CREATE PUBLIC SYNONYM plgiseg FOR plgiseg;                                      
GRANT EXECUTE ON plglst TO PUBLIC;                                              
DROP PUBLIC SYNONYM plglst;                                                     
CREATE PUBLIC SYNONYM plglst FOR plglst;                                        
GRANT EXECUTE ON plgobj TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgobj;                                                     
CREATE PUBLIC SYNONYM plgobj FOR plgobj;                                        
GRANT ALL ON plg_doir TO PUBLIC;                                                
DROP PUBLIC SYNONYM plg_doir;                                                   
CREATE PUBLIC SYNONYM plg_doir FOR plg_doir;                                    
GRANT EXECUTE ON plgofst TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgofst;                                                    
CREATE PUBLIC SYNONYM plgofst FOR plgofst;                                      
GRANT EXECUTE ON plgpky TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgpky;                                                     
CREATE PUBLIC SYNONYM plgpky FOR plgpky;                                        
GRANT EXECUTE ON plgprs TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgprs;                                                     
CREATE PUBLIC SYNONYM plgprs FOR plgprs;                                        
GRANT EXECUTE ON plgstk TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgstk;                                                     
CREATE PUBLIC SYNONYM plgstk FOR plgstk;                                        
GRANT EXECUTE ON plgstr TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgstr;                                                     
CREATE PUBLIC SYNONYM plgstr FOR plgstr;                                        
GRANT EXECUTE ON plgvar TO PUBLIC;                                              
DROP PUBLIC SYNONYM plgvar;                                                     
CREATE PUBLIC SYNONYM plgvar FOR plgvar;                                        
GRANT EXECUTE ON plgplsql TO PUBLIC;                                            
DROP PUBLIC SYNONYM plgplsql;                                                   
CREATE PUBLIC SYNONYM plgplsql FOR plgplsql;                                    
GRANT EXECUTE ON plgjava TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgjava;                                                    
CREATE PUBLIC SYNONYM plgjava FOR plgjava;                                      
GRANT EXECUTE ON plghash TO PUBLIC;                                             
DROP PUBLIC SYNONYM plghash;                                                    
CREATE PUBLIC SYNONYM plghash FOR plghash;                                      
GRANT EXECUTE ON plgihash TO PUBLIC;                                            
DROP PUBLIC SYNONYM plgihash;                                                   
CREATE PUBLIC SYNONYM plgihash FOR plgihash;                                    
GRANT EXECUTE ON plgcgml TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgcgml;                                                    
CREATE PUBLIC SYNONYM plgcgml FOR plgcgml;                                      
GRANT EXECUTE ON plgtype TO PUBLIC;                                             
DROP PUBLIC SYNONYM plgtype;                                                    
CREATE PUBLIC SYNONYM plgtype FOR plgtype;                                      
GRANT EXECUTE ON plgsrchash TO PUBLIC;                                          
DROP PUBLIC SYNONYM plgsrchash;                                                 
CREATE PUBLIC SYNONYM plgsrchash FOR plgsrchash;                                
GRANT ALL ON plg_source TO PUBLIC;                                              
DROP PUBLIC SYNONYM plg_source;                                                 
CREATE PUBLIC SYNONYM plg_source FOR plg_source;                                
GRANT ALL ON plg_driver_source TO PUBLIC;                                       
DROP PUBLIC SYNONYM plg_driver_source;                                          
CREATE PUBLIC SYNONYM plg_driver_source FOR plg_driver_source;                  
GRANT ALL ON plg_doir TO PUBLIC;                                                
DROP PUBLIC SYNONYM plg_doir;                                                   
CREATE PUBLIC SYNONYM plg_doir FOR plg_doir;                                    
GRANT ALL ON oir_allprivs TO PUBLIC;                                            
DROP PUBLIC SYNONYM oir_allprivs;                                               
CREATE PUBLIC SYNONYM oir_allprivs FOR oir_allprivs;                            
GRANT ALL ON oir_global_tfile TO PUBLIC;                                        
DROP PUBLIC SYNONYM oir_global_tfile;                                           
CREATE PUBLIC SYNONYM oir_global_tfile FOR oir_global_tfile;                    
GRANT ALL ON oir_global_wrap TO PUBLIC;                                         
DROP PUBLIC SYNONYM oir_global_wrap;                                            
CREATE PUBLIC SYNONYM oir_global_wrap FOR oir_global_wrap;                      
GRANT ALL ON oir_identifier TO PUBLIC;                                          
DROP PUBLIC SYNONYM oir_identifier;                                             
CREATE PUBLIC SYNONYM oir_identifier FOR oir_identifier;                        
GRANT ALL ON oir_schema_tfile TO PUBLIC;                                        
DROP PUBLIC SYNONYM oir_schema_tfile;                                           
CREATE PUBLIC SYNONYM oir_schema_tfile FOR oir_schema_tfile;                    
GRANT ALL ON oir_schema_wrap TO PUBLIC;                                         
DROP PUBLIC SYNONYM oir_schema_wrap;                                            
CREATE PUBLIC SYNONYM oir_schema_wrap FOR oir_schema_wrap;                      
GRANT ALL ON oir_table_tfile TO PUBLIC;                                         
DROP PUBLIC SYNONYM oir_table_tfile;                                            
CREATE PUBLIC SYNONYM oir_table_tfile FOR oir_table_tfile;                      
GRANT ALL ON oir_table_wrap TO PUBLIC;                                          
DROP PUBLIC SYNONYM oir_table_wrap;                                             
CREATE PUBLIC SYNONYM oir_table_wrap FOR oir_table_wrap;                        
GRANT ALL ON oir_driver TO PUBLIC;                                              
DROP PUBLIC SYNONYM oir_driver;                                                 
CREATE PUBLIC SYNONYM oir_driver FOR oir_driver;                                
GRANT ALL ON oir_all_generations TO PUBLIC;                                     
DROP PUBLIC SYNONYM oir_all_generations;                                        
CREATE PUBLIC SYNONYM oir_all_generations FOR oir_all_generations;              
GRANT ALL ON oir_user_generations TO PUBLIC;                                    
DROP PUBLIC SYNONYM oir_user_generations;                                       
CREATE PUBLIC SYNONYM oir_user_generations FOR oir_user_generations;            
GRANT EXECUTE ON plgconfirm TO PUBLIC;                                          
DROP PUBLIC SYNONYM plgconfirm;                                                 
CREATE PUBLIC SYNONYM plgconfirm FOR plgconfirm;                                
GRANT EXECUTE ON plgconfirm_eval TO PUBLIC;                                     
DROP PUBLIC SYNONYM plgconfirm_eval;                                            
CREATE PUBLIC SYNONYM plgconfirm_eval FOR plgconfirm_eval;                      
GRANT EXECUTE ON genxconfirm TO PUBLIC;                                         
DROP PUBLIC SYNONYM genxconfirm;                                                
CREATE PUBLIC SYNONYM genxconfirm FOR genxconfirm;                              
GRANT EXECUTE ON genxconfirm_eval TO PUBLIC;                                    
DROP PUBLIC SYNONYM genxconfirm_eval;                                           
CREATE PUBLIC SYNONYM genxconfirm_eval FOR genxconfirm_eval;                    
GRANT EXECUTE ON plgnamex TO PUBLIC;                                            
DROP PUBLIC SYNONYM plgnamex;                                                   
CREATE PUBLIC SYNONYM plgnamex FOR plgnamex;                                    
GRANT ALL ON plgnamex_word TO PUBLIC;                                           
DROP PUBLIC SYNONYM plgnamex_word;                                              
CREATE PUBLIC SYNONYM plgnamex_word FOR plgnamex_word;                          
GRANT ALL ON plg_doir_seq TO PUBLIC;                                            
DROP PUBLIC SYNONYM plg_doir_seq;                                               
CREATE PUBLIC SYNONYM plg_doir_seq FOR plg_doir_seq;                            
GRANT ALL ON plggen_seq TO PUBLIC;                                              
DROP PUBLIC SYNONYM plggen_seq;                                                 
CREATE PUBLIC SYNONYM plggen_seq FOR plggen_seq;