Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Small sample shell program Linux/Unix
  • Find Command Linux/Unix
  • Library cahe Latches and internal explaination Oracle
  • How to see which patches are applied. Oracle
  • Good Link from metalink 1 Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Paste command syntax Linux/Unix
  • temp_use.sql diplays usage of temp ts Oracle
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • sqlnet.ora paramters Oracle
  • Sample WW22 listener.ora Oracle
  • Optimizer_Index init.ora parameter explaination. Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • load SPM baseline from cursor cache Oracle
  • Check Oracle installed products using one command 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

  • Insert cause enqueue locks Oracle
  • When error comes for temporary tablespace with version <= 9i Oracle
  • column level grant syntax Oracle
  • Ports used by Oracle Software Oracle
  • Jai Shree Ram Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. 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 (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • find_pk.sql /* Find Primary Key */ Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • Find average Row Length and other table size calculation. metalink notes Oracle
  • oracle 11g RAC on vmware Oracle
  • telnet listening Linux/Unix
  • Good Link from metalink 1 Oracle
  • Export Oracle data and Compress at same time Oracle
  • DBMS_Shared_pool pinning triggers Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme