Re: Privileges by session
Date: Thu, 07 Jan 2010 15:35:53 -0500
Message-Id: <8CC5DF02456027A-13E8-2C40_at_web-mmc-d16.sysops.aol.com>
Would Default Roles help? Do your developers log in through SQL*Plus? I'm not sure if that would help. Just throwing it out there, i guess. Lyall
-----Original Message-----
From: Blanchard, William <wblanchard_at_societyinsurance.com>
To: oracle-l_at_freelists.org
Sent: Thu, Jan 7, 2010 3:21 pm
Subject: Privileges by session
Greetings,
I have convinced management to allow me to grant read-only access to the developers. The problem is that they know the application passwords and have been using those passwords to circumvent my controls. Is there a way via a trigger, role, etc to change individual sessions privileges so they have read only (select) permissions? The easiest way would be to change the permissions on the applications but that's not an option.
Thank you,
WGB
-
This email and any information, files, or materials transmitted with it
re confidential and are solely for the use of the intended recipient.
f you have received this email in error, please delete it and notify
he sender.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 07 2010 - 14:35:53 CST