Database Security Products (MOSC)

MOSC Banner

stop users making full table scans on a single table.

edited Oct 7, 2009 11:18PM in Database Security Products (MOSC) 4 comments
 Wow, I like this new forum!

I have a quick question- how can I approach preventing a "select * from table_name" on a certain table?  I have an application running forms 6i- I am not good at forms so I was considering a table triggger on the database level.  However, forms opens a sql query in a different format then just a simple select * from table_name.  My question is that if I create a trigger on the table will if fire on a full table query from a forms event?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center