Re: locking

From: Paul Drake <bdbafh_at_gmail.com>
Date: Wed, 8 Jul 2015 14:17:58 -0400
Message-ID: <CAPptggW07Z5u8T=raB2+WBnWCKW0-zug2yBkgn3vOC7RxrpnfA_at_mail.gmail.com>

Expose the underlying tables via a view with a read only check constraint with no direct grants on the underlying tables to the user account that the app Access uses to connect to the target database instance?

Other thoughts:
Drop user
Alter user account lock
Revoke create session from :offender
Refer them to a reporting database instead

Paul
On Jul 8, 2015 2:12 PM, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> wrote:

> Does an Access front end lock tables in Oracle on selects? Is there a
> way to make sure that it can’t?
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 08 2015 - 20:17:58 CEST