Board index ORACLE

Grant Select without Grant Update

Grant Select without Grant Update

Post by Bob Murph » Mon, 02 May 2005 23:09:50


Oracle EE 9.2.0.6 without extra cost options is being used for housing
production OLTP data. In-house developers occasionally use TOAD 8,
SqlPlus 9.2.0.6, etc. to query the production data while debugging
end-user complaints. One third-party tool issued a SELECT FOR UPDATE
when a developer intended only to SELECT the row. This developer did
not have any update privileges, but the database created the row lock
just the same, blocking legitimate updates while the lock is held by
this read-only developer. This blocking ability can delay a millisecond
response for normal updates.

The developers will modify their usage for the offending tool. But, is
there a recommended workaround that the DBA could implement at the
database level to prevent SELECT FOR UPDATE by read-only end-users?
 
 
 
Top

1. Granting the ability to shadow without granting admin permissi

2. Granting the ability to shadow without granting admin permissions

Greetings.

Is there a way to grant a user the ability to shaodw another session without
granted local server admin rights to the user?

Thanks.

3. GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLI

4. GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLIC

5. subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=SYSTEM=f Fails

6. Granting GRANT permissions

7. Memory grants outstanding and Memory grants pending

8. Thanks - but no luck with the grant: mysql> grant ALL on *.* to'root'@'10.1.2.

9. subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=SYSTEM=f fails

10. GRANT CREATE DATABASE versus GRANT ALTER ANY LOGIN

11. doing select without grant

12. Grant global select/insert/update/delete to all users

13. Granting user exec on stored proc with dynamic sql without granting select priv on sql query table

14. How to grant EM tools without sysadmin role

15. user can view another user's calendar without granted permission

All times are UTC
Board index