Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • DBA_HIST_SQLSTAT contents Oracle
  • How to analyze statspack or AWR report. Oracle
  • login.sql Oracle
  • PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
  • move_arch_files.ksh Linux/Unix
  • lck.sql Oracle
  • Oracle Material from OTN Oracle
  • Roles and Stored Procs II Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • switchlogfile.sh Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • how to find VIP from ifconfig Linux/Unix
  • scripts to take listener.log backup Linux/Unix
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • Drop all SPM baselines for SQL handle Oracle

Privileges Required to Create Procedures and Functions that uses objects from other schema.

Posted on 13-Jan-2006 By Admin No Comments on Privileges Required to Create Procedures and Functions that uses objects from other schema.

When you are creating a procedure and you are using objects from other schemas, then the procedure owner needs related privilages exclusively on those objects of other schemas. This cannot be resolved with ROLE.

Oracle, SQL scripts

Post navigation

Previous Post: Settting up get_vmstat.sh for colletinf CPU Usage.
Next Post: Removing first line

Related Posts

  • V$ROLLSTAT status is Full Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • Database link password in user_db_links Oracle
  • Good Doc 28-JUN-2006 Oracle
  • Convert multiple rows to single column Oracle
  • executing Function from SQLPLUS prompt Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Linux CPU info. Linux/Unix
  • pvm_rbs1.sql (to collect rbs info from db) Oracle
  • move_arch_files.ksh Linux/Unix
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • FGA Part-I Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • login.sql Oracle
  • Processes Parameter decision Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme