Re: Grant privileges to "a program"...?

From: Dr. Blue <ramirez_at_iastate.edu>
Date: 1996/11/12
Message-ID: <56afsr$ots_at_news.iastate.edu>#1/1


Another idea is to have a script (a demon) that cancels all sessions using an "undesirable" program. V$SESSION has some information about the user's program and you could write a PL/SQL procedure that every few minutes checks who is using what. Perhaps even a trigger combined with an automatic insert whenever someone logs on.

Richard

In article <5657gj$16q2_at_watnews1.watson.ibm.com>, mlanda_at_vnet.ibm.com writes:

|> In <564m7u$6l1_at_ds9.Dortmund.loca.net>, volker.koenig_at_Duesseldorf.netsurf.de (Volker Koenig) writes:

|> >Hi there!
|> >
|> >A collegue just claimed it was possible to grant table privileges to "a
|> >program" in oracle, e.g., not the id of the user is checked against the
|> >table-privileges but the name or any "hidden" id of the application program
|> >itself.
|> >
|> >This will make it possible - especially when using ODBC - to avoid people
|> >using tables with "non applications" like word processors or spreadsheets.
|> >
|> >Is this true or did someone "tell him about his horse", as we say in germany?
|> >
-- 
Richard G. Ramirez, Ph. D.
Assistant Professor of MIS
Iowa State University
Received on Tue Nov 12 1996 - 00:00:00 CET

Original text of this message