Re: The drop a table column package.

You might look at USER_TAB_PRIVS_MADE to see where oracle stores what grants have been issued by a user.

Joseph S. Testa (jtesta_at_scioto.net) wrote:
: This is a multi-part message in MIME format.
: --------------679B8104FED5E253DB6210A7
: 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).

: --------------679B8104FED5E253DB6210A7
: 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

: --------------679B8104FED5E253DB6210A7--

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.