Only grant them select privs. eg
grant select on myTable to george;
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Erwin1971" <schilt_at_hotmail.com> wrote in message
news:dde832f0.0306050615.4af57b90_at_posting.google.com...
> 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.
Received on Thu Jun 05 2003 - 09:36:29 CDT
