Re: Find the table's name that using sequences

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 16 Jul 2003 14:58:48 -0400
Message-Id: <25937.338114@fatcity.com>

Michell,
A sequence is created and select privileges granted to users or roles. The users or roles use the sequence in the applications to insert/update the data in the tables. Check the privileges granted to the users/roles and then get the info from the developers as to which tables use the sequence. A daunting task is in your future if you do not have your database documented.
Good luck,
Ron

>>> mitchell.lee_at_rogers.com 07/16/03 03:09PM >>>
Hi All

At first I thought it is easy to find those tables to use sequences but
I failed. dba_sequence don't give too much info. Is there any idea?

Thanks in advance Received on Wed Jul 16 2003 - 13:58:48 CDT