| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about Record Locks
Todd Matson wrote:
>
> If I have SELECT privileges only, is there anything I can do that will
> create a record lock?
>
> Here's my situation: I have written a reporting tool which has SELECT
> privileges on a database. On rare instances, another application fails when
> it tries to make updates to the database. Now the DBA is asking me if my
> reporting application does anything which might cause the updates to fail
> (for instance, creating exclusive record locks). It is my understanding that
> I simply cannot do anything to interfere, even if I want to, as long as I
> have SELECT privileges only. Am I wrong about that?
>
> I should mention that I am not running any stored procedures and I'm
> executing my queries through ODBC.
>
> -Todd Matson
Theoretically no...
You may wish to confirm exactly what calls your reporting tool is doing by issuing either "alter session set sql_trace = true" or "dbms_session.set_sql_trace(true)" at the start of the report run and use tkprof to see whether it was "sneaking" any update calls in...
HTH --
 |
 |