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
Messages: 13
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.


[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: 68417
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
Goto Forum:

Current Time: Thu Mar 23 00:19:48 CDT 2023