OraFAQ Forum: Security » How to prohibit execute select for upate

Home » RDBMS Server » Security » How to prohibit execute select for upate (oracle 11g, linux redhat)

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

How to prohibit execute select for upate [message #639215]

Thu, 02 July 2015 20:57

zxx2403
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.

Thanks

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

Report message to a moderator