OraFAQ Forum: Security » Prevent users from updating tables

Home » RDBMS Server » Security » Prevent users from updating tables (Oracle 9iR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Prevent users from updating tables [message #474817]

Thu, 09 September 2010 03:05

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

Report message to a moderator

Re: Prevent users from updating tables [message #474818 is a reply to message #474817]

Thu, 09 September 2010 03:24

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do not grant the privilege to update to anyone but application users.

Regards
Michel

Report message to a moderator

Re: Prevent users from updating tables [message #474865 is a reply to message #474818]

Thu, 09 September 2010 06:55

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?

Report message to a moderator

Previous Topic:	New procedures not working even after granting EXECUTE
Next Topic:	Logon Denied

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 29 02:46:31 CDT 2025