Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • proc.sql Oracle
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • switchover for primary database Oracle
  • Committing distributed transaction using commit force Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • Convert multiple rows to single column Oracle
  • SQL_PLAN.sql for checking real execution plan Oracle
  • Caching sequence in Memory Oracle
  • eplan.sql Oracle
  • For Search and replace unix command. Linux/Unix
  • replace alphabets using sed Linux/Unix
  • All About oracle password and security from metalink Oracle
  • Optimizer_Index init.ora parameter explaination. Oracle
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • cold backup scripts to copy locally Linux/Unix

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

  • Running PDB on single node in RAC Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Rollback force for distributed transactions Oracle
  • sid_wise_sql.sql Further explaination Oracle
  • ext#.sql Oracle
  • block_ident.sql Oracle

Leave a Reply Cancel reply

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

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Proc Compilation Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • plan10g.sql Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • plan10g.sql good Oracle
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • Implementing Listener Security Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme