Home » SQL & PL/SQL » SQL & PL/SQL » SELECT qry doubt ...
SELECT qry doubt ... [message #185743] Thu, 03 August 2006 06:32 Go to next message
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
Re: SELECT qry doubt ... [message #185811 is a reply to message #185743] Thu, 03 August 2006 13:28 Go to previous messageGo to next message
Messages: 7880
Registered: March 2000
Senior Member
what front-end are your users on? How do they enter their queries?
Re: SELECT qry doubt ... [message #185894 is a reply to message #185743] Fri, 04 August 2006 02:07 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
So do your end users type in and execute ad-hoc queries frequently?
Previous Topic: Pro *c Vs Stored procedures
Next Topic: Collections Error
Goto Forum:

Current Time: Sat Jul 22 06:13:06 CDT 2017

Total time taken to generate the page: 0.20886 seconds