Printable View
I have an application where users with only Connect & Resource roles lock elements using 'select for update.' Is it possible for these users to see any info (as a debug tool for our development) on what rows are locked in the schema without being DBA or having privs added? All the queries I can find on locks and sessions require more than Connect & Resource.
Thanks
-mcslain
doubt it, even as a DBA it's not trivial to know exactly which rows are locked, I do NOT recommend anyways querying dynamic views in an application, they are special and they are for special people. The problem with dynamic views are:
1. They are not consistent, i.e the data they returns might no be the data you are looking for
2. They are dangerous, querying views such as v$sql may hangs an instance. You may say you wont use it but the developers are like this, if they are allowed to use some v$ then they think they can use more and asks for more and more
3. They may change with versions
4. Bugs
I'm wondering why a plain user might be interested in knowing what rows are locked. Locking is what makes rdbms possible, they shouldn't be concerned about it.
Going back to your original question Is it possible for these users to see any info (as a debug tool for our development) on what rows are locked... the answer is: No.