I want know how to prevent select for update from users without update grant.

Author: asktom.oracle.com | Published: 3rd Jan 2008 | Visited: 48 times | Add Comment
Filed in: Oracle FAQ

Hi Tom, Thank you for this space for doubts. I want know how to prevent select for update from users without update grant. Follow the example below: <code> create user test1 identified by test1; grant connect,resource to test1; create ...

Read Article

Sponsored Links

• A Look at MapQuest's Users .vbutton {padding:5px; border:groove 3px; background-color:#c0cCFF; color:white; font-family:Verdana; text-align:center; font-weight:bold; font-size:12pt; cursor:pointer;} .vbutton:hover {background-color:#e0e0ff;border:outset;} .vbutton:active {background-color:#a0a0ff;border:inset;} O'Reilly ...

• RESTRICT USERS TO INSERT/UPDATE DATA EXCEPT THEIR PRIVILIEGES DEAR TOM i learn a lot from this platform as a new dba i have a situation here. i did't write code/script here because i havn't any idea that how i ask from you? i have tried to convey my.. i have a database of almost 60 tables. application d ...

• LINQ TO SQL All Common Operations (Insert,Update,Delete,Get) in ONE BASE Class Base Class to perform all Common LINQ To SQL Operat ...

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• Referencing values in update trigger Tom, When a before update for each row trigger fires and a certain column was not set in the update statement, the :new value for the "certain column" appears to be set to the :old value by the time the trigger fires. Is there a way to determine ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• TDL: Protocol for .dan.g.'s ToDoList, Useful for SVN Users Register a fake protocol of TDL: to make tdl:///filename.tdl?tid avail ...

• Article :: 4Ci Update: More Solutions for Command, Control, and Communications in Time of Disaster Every organization should be prepared with alternative methods for accessing communications systems in case of an emergen ...

• Java SE 6 Update 10 Beta This update introduces new Java Plug-In, Java Kernel, Java Deployment Toolkit, new Java system properties, Java Quick Starter, hardware acceleration support, and Nimbus to provide an optimized consumer-end user experie ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

Next: PLSQL Web Toolkit