Re: Select after update

Originally posted by Erwin1971
> 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.

Use roles and privileges to do that:

grant select on table1 to select_only_role; grant select on table2 to select_only_role; ..
(DO NOT grant insert, update, delete on anything to that role)

grant select_only_role to user1;
grant select_only_role to user2;
..

--
Posted via http://dbforums.com