Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • lck.sql Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • move_arch_files.ksh Linux/Unix
  • sqlnet.ora paramters Oracle
  • Drop specific SQL plan baseline – spm Oracle
  • create database link syntax Oracle
  • Oracle Material from OTN Oracle
  • My Minimum Tuning Programs Oracle
  • myfile Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Find All internal Parameters Oracle
  • checking redhat linux version 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

  • create PLAN_TABLE command. Oracle
  • Physical Standby switchover with session active Oracle
  • block_ident.sql Oracle
  • get_vmstat.ksh for Solaris Oracle
  • useful dg links Oracle
  • perf_today.sql Oracle

Leave a Reply Cancel reply

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

Categories

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

Recent Posts

  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • executing Function from SQLPLUS prompt Oracle
  • Drop database in Oracle 10g Oracle
  • normal maintenance for exp-imp and renaming table Oracle
  • Oracle Material from OTN Oracle
  • Good RAC & Standby Notes Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • Error Handling in Proc Oracle
  • How to analyze statspack or AWR report. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme