Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select after update
Erwin1971 wrote:
> I'm curious if it's possible, if an SQL statement starts with
> "Select", to make changes to the database you are using. Like a
> statement Select...after update...I would like to create a control so
> that users can only make sql statements to view the database not to
> alter it.
The Database Administrator's Guide (at http://docs.oracle.com) is particularly useful here. The sections you want to look at include: 'security' and 'privileges'. The discussion is relatively complete! /Hans Received on Thu Jun 05 2003 - 16:54:21 CDT