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
|> >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?
|> >
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 UniversityReceived on Tue Nov 12 1996 - 00:00:00 CET