The table drop column package
Date: 1997/10/02
Message-ID: <343440FE.53D018AC_at_scioto.net>#1/1
This is a multi-part message in MIME format.
--------------F4B19C49B430D9055F3B633F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
As I am doing the extra checks for doing FK checks, I have stumbled upon
a problem, here is the scenario:
User A creates table A1, and grants references on table to user B. user B creates table b1 and sets fk to point to a(a1).
Nowhere I have been able to find the reference that user B has made to user a's a1 table. The assumption here is NEITHER has access to any DBA
views. I have looked at all_dependencies, all_constraints, all_cons_columns to no avail.
I realize that unless user A has alter any table that the FK could NOT be reset anyways, but I'd like to warn the user that there is a FK that may not be able to be reset AFTER the new table is created with out the column that they wanted dropped.
I think the best i can do at this point, is let the user know if there has been references granted to some user for that table, based on info out of all_tab_privs_made.
Any ideas would be appreciated, thanx, joe
--
--
Joseph S. Testa, Oracle Database Administrator
Are you looking for Oracle DBA in Central Ohio, but only want one for
some part-time work? try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second,
third, etc, instance, without using oracle's installer, database
scripts.
ICQ UIN: 2814105(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).
--------------F4B19C49B430D9055F3B633F
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Joseph S. Testa Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Joseph S. Testa n: Testa;Joseph S. org: Origin Technology in Business adr: ;;;;OH;;USA email;internet: jtesta_at_scioto.net title: Oracle DBA note: Oracle DBA in central Ohio and doing geneaology research on Testa family, I have 2 ICQ uins, home: 2814105, work 2832230, you can also find me on netscape conference.x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version: 2.1 end: vcard
--------------F4B19C49B430D9055F3B633F--
Received on Thu Oct 02 1997 - 00:00:00 CEST