Home » RDBMS Server » Security » Prevent users from updating tables (Oracle 9iR2)
Prevent users from updating tables [message #474817] Thu, 09 September 2010 03:05 Go to next message
papu
Messages: 27
Registered: March 2005
Location: Dhaka
Junior Member

hi all,

i've created a schema, which contains 30 tables. the tables are accessed & updated through a web based application. i've made public synonym for all tables for some reasons. how can prevent any one other than application users from updating the tables from Sqlplus.

regards


papu
Re: Prevent users from updating tables [message #474818 is a reply to message #474817] Thu, 09 September 2010 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not grant the privilege to update to anyone but application users.

Regards
Michel
Re: Prevent users from updating tables [message #474865 is a reply to message #474818] Thu, 09 September 2010 06:55 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Why would you not block updates anyway unless there was a requirement, in which case, appriove the specific user to perform updates?
Previous Topic: New procedures not working even after granting EXECUTE
Next Topic: Logon Denied
Goto Forum:
  


Current Time: Thu Mar 28 17:40:14 CDT 2024