Home » RDBMS Server » Security » How to prohibit execute select for upate (oracle 11g, linux redhat)
How to prohibit execute select for upate [message #639215] Thu, 02 July 2015 20:57 Go to next message
zxx2403
Messages: 12
Registered: November 2006
Location: china
Junior Member

Hi All,

We have a role named qry_role. and grant select on table privelege to this role.

for example

grant select on emp to qry_role.

But we found we can not only execute the select * from emp statement but also execute

select * from emp for update statement. For update statament will lock the table rows.

How can we only let qry_role execute select * from table.

Thanks

[Updated on: Thu, 02 July 2015 21:00]

Report message to a moderator

Re: How to prohibit execute select for upate [message #639216 is a reply to message #639215] Thu, 02 July 2015 23:52 Go to previous message
Michel Cadot
Messages: 65201
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Short answer: you can't.

Previous Topic: Oracle Advaned Security TDE Configuration Set Up Question
Next Topic: PRIVILEGES FOR TABLE FUNCTION
Goto Forum:
  


Current Time: Tue Nov 21 04:21:03 CST 2017

Total time taken to generate the page: 0.01619 seconds