RE: Changing USER_TAB_COLUMNS Synonym

  • From: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
  • To: oracle@xxxxxxxxxxx, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Oct 2016 07:58:48 -0700 (PDT)

Instead of hacking the data dictionary, why not just fix your application? 
Breaking the database for just the app instead of fixing the app doesn't seem 
like a good idea.

-----Original Message-----
From: Dave Morgan [mailto:oracle@xxxxxxxxxxx] ;
Sent: Tuesday, October 18, 2016 10:57 AM
To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
Subject: Changing USER_TAB_COLUMNS Synonym

Hello All,
        Does anyone know of bad consequences or side effects to altering a 
single schema's USER_TAB_COLUMNS  synonym to point at ALL_TAB_COLUMNS?

Our sophisticated developers used a data owner schema in their ORM to code 
against and since they don't have access to those accounts in production 
........


--
Dave Morgan
Senior Consultant, 1001111 Alberta Limited dave.morgan@xxxxxxxxxxx
403 399 2442
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: