| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: HELP - How can I limit what program users use to connect?
You can use a password protected role which is only enabled in the executable using a stored package that executes dbms_session.set_role.
The package checks which program name invoked it be querying v$session.program.
If the role is not enabled, users not granted the role do not have access to the database objects.
This is described in Oracle Security book in chapter 9.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike J Kurth
INET: Mike.J.Kurth_at_aexp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 22 2001 - 12:19:59 CDT
 |
 |