Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • move_arch_files.ksh Linux/Unix
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • DBMS_UTILITY PACKAGE Oracle
  • How can I tell if ASO is installed ? Oracle
  • restarting network in linux Linux/Unix
  • Unix command for system configuration Linux/Unix
  • Drop all SPM baselines for SQL handle Oracle
  • Good notes on Oracle Events Oracle
  • My FTP Job Scheduling for www.pvmehta.com PHP/MYSQL/Wordpress
  • Recovering lost SYS password Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • find checksum of a file. Linux/Unix
  • Rollback force for distributed transactions Oracle
  • Pending Transaction Neighbors Script Oracle

My Test Case On 21-OCT-2005

Posted on 21-Oct-2005 By Admin No Comments on My Test Case On 21-OCT-2005

(*) if you grant any role to grantee while grantee is connected to database. He cannot use that role immediately. To use it immediately he needs to execute “Set role role_name” in his session. This will enable that role for him or he needs to logoff and login again.

(*) If you have given any object level grant to grantee, grantee need to execute that as fully qualified path for accessing that object. To access object with simple name you need to create private synonym in grantee’s schema.

(*) If a table is aletered,

(1) its associated trigger & views (dba_dependencies) become invalid.

(2) If some other user are accessing this then trigger and views are compiled automatically and executed if they compiled successfully.

(3) Grants remain intact while this process.

(*) If a table is renamed then

(1) associated trigger, views become invalid.

(2) synonyms that are pointing to this table from other user also unable to resolve target object name and gives ORA-00980 “synonym trnaslation is no longer valid”.

(3) Grantee has all object level grants intact on this new object and this renamed object can be still access with fully qualified name (with schemaname). so user can user those grant. If grantee/owner is able to execute some DML that initiate trigger then trigger will be compiled and validated.

(4) The only problem is view. For views, you need to modify its definition manually and compile. You donot need to re-grant again.

(*) if table is droppped then

(1) Associated trigger also dropped. Views become invalid.

(2) Synonyms that are pointing to this table from other user also unable to resolve target object name and gives ORA-00980 “synonym trnaslation is no longer valid”.

Oracle, SQL scripts

Post navigation

Previous Post: TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1
Next Post: USER_TABLES.Freelists

Related Posts

  • Recovering lost SYS password Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • run this before doing any dbchange pvm_pre_change.sql Oracle
  • Find nth max and min. Oracle
  • Vivek Tuning for Row Locks. Oracle
  • Wait Based Tuning Step by step with SQL statement 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
  • db_status.sql Oracle
  • To see only files and/or folders using LS command Linux/Unix
  • Absolute file number and relative file number Oracle
  • myfile Oracle
  • Key Management in Oracle: The Core Issue: Missing Master Key Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • shutdown linux Linux/Unix
  • CPU speed on solaris Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme