OraFAQ Forum: SQL & PL/SQL » SELECT qry doubt ...

Home » SQL & PL/SQL » SQL & PL/SQL » SELECT qry doubt ...

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

SELECT qry doubt ... [message #185743]

Thu, 03 August 2006 06:32

frank.svs
Messages: 162
Registered: February 2006

Senior Member

Hi frns,

A small doubt.I have EMP table.Can i restrict users to use the WHERE CLAUSE. For example
I must allow users to use WHERE clause only based on deptno.Something like

select * from emp where deptno=<value>

And users are not allowed to use the WHERE clause based on other columns in EMP table.
Its a bussiness rule. Can i do that ???

Thanks in advance
franky

Report message to a moderator