Revoke update, insert and delete from the users, and grant execute
privilege on a procedure/function/package that will do the required
updates.

Bart Cortenbach





Michael Parry <[Email Address Removed] on 2003-01-31 12:54:37

To: "LazyDBA.com Discussion" <[Email Address Removed] SQLPlus insert,update,delete access limitations


Ok Guru's,

I need to come up with a process that prevents users
from using sqlplus at the command line for insert,
update and delete. They can have select though.
Normally this would not be a problem as I would use
the user_profiles to limit this. The catch is that
they run shell scripts that use sqlplus to perform the
updates. This means that users need update access in
the shell scripts, but select only at the command line
or through sqlplus client.

Anybody have any ideas?

Thanks, Mike

=====
Michael Parry
Unisys - Oracle DBA/Sys Adm
DSN: 525-9162 COM: 661-275-9162
[Email Address Removed] you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html






Oracle LazyDBA home page