Alternate solution for Reference Qualifier

[Nayan Mule]

Hi All,

I was asked in an interview to have a filter on caller id whose Department is for eg. "IT" .

But this has to be achieved without using reference qualifier, I was not sure on that moment.

Is there any other way through which we can achieve this without using reference qualifier ?

Thanks in Advance

[Brad Bowman]

Being an interview, I guess they were looking for a 'thinking outside the box' type response, not the best way to achieve the result.  An ACL on the sys_user table would do that (and more than is intended/needed as it is system-wide).