Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


Grant permission to all packages in another schema


Is there a way I can grant access to all the packages in another user's schema?  Please guide me.  Thanks!

The one way is to use cursor : BEGIN   FOR Rec IN (SELECT object_name, object_type FROM all_objects WHERE owner='SOURCEUSER' AND object_type IN ('PACKAGE')) LOOP       EXECUTE IMMEDIATE 'GRANT EXECUTE ON SOURCEUSER.'||Rec.object_name||' TO TARGETUSER';     END IF;   END LOOP; END;   Edited by: Radrigez on 13.07.2011 21:38

set head off set linesize 200 set pages 2000 spool grant.sql select 'grant execute on '||name||' to TARGETUSER;' from user_source where type='PACKAGE'; spool off @grant.sql 

user645399 wrote: Is there a way I can grant access to all the packages in another user's schema?  Only when you have privileges to do so.  Everything is forbidden; except those explicitly GRANTed.

Is there a way I can grant access to all the packages in another user's schema?  1) grant execute on pkg1 to sys with grant option  2) grant execute on user1.pkg1 to user2;


Related Links

Extracting NUMBER type in binary using Dynamic SQL Method 4
Delphi, BDE and Oracle 9i
9i Error messages
Use sqlnet client from 9.01 Release in a 9.02 Installation?
Displaying mhtml via PL/SQL
9i database error messages
Toad and Oracle Client
Best Practice paper for Security
Converting UTF8 to WE8MSWIN1252
procedure
unable to extend table
oracle 9i
Oracle index and constraint behaving vary strangely!
Run RMAN using UTL_FILE
creation of new database
Recover table with no export backup