Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • Vivek Tuning for Row Locks. Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • find_cons.sql Oracle
  • cache buffer chain latch Oracle
  • Changing the Global Database Name Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • To see how much time or progress of long transaction Oracle
  • Handling LOB data in Oracle Oracle
  • FGA Part-I Oracle
  • set_env_dba Linux/Unix
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • checking connectivity between two servers Linux/Unix
  • create database link syntax 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

  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • Monitor Long Running Job Oracle
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • ORA-01220 Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • refre.sql 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • handling filenname with space Linux/Unix
  • online_bkup.sql Oracle
  • SQL_PROFILE – I explaination Oracle
  • Flowers Resize datafiles Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Renaming the column name Oracle
  • Find_table_size.sql Oracle
  • scripts to take listener.log backup Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme