Re: How to recognise Front-End tool in the View?

In article <3p1mh8$lno_at_lantana.singnet.com.sg> setiawan_at_singnet.com.sg (Eddy Setiawan) writes:
>From: setiawan_at_singnet.com.sg (Eddy Setiawan)
>Subject: How to recognise Front-End tool in the View?
>Date: Sat, 13 May 1995 07:15:59 GMT
 

>Hi,
 

>I have a based table TABLE1_BASED, and I create a view called TABLE1.
>And then I grant access to the view TABLE1 to user JOHN.
 

>Is it possible to limit JOHN's access to the data in TABLE1 only when
>he used in-house developed applications (using: PowerBuilder,
>SQLWindows, Oracle*Form, etc), and not when he login via SQL*Plus or
>Data Browser?
 

>What I'm trying to achieve is that when he login using SQL*Plus or
>Data Browser, he can't *see* any data in TABLE1. But when he login
>using in-house applications, he can see the data. The reason for this
>is because our in-house applications will *control* the data to be
>displayed, but we also need to have Data Browser for ad-hoc queries.
 

>Thanks in advance. Any advise or solutions are welcomed.
 

>Regards,
 

>--
>Eddy Setiawan, DBA
>National Computer Board of Singapore (NCB)
>e-mail: setiawan_at_singnet.com.sg
>phone: +65 330 6779 fax: +65 337 8455 telex: RS 26233
>Disclaimer: Opinions expressed are strictly private.

Use non-default roles and enable them inside your application. Make the user's default role one that just has select on the tables you want him to see.

Lawrence.... Received on Tue May 16 1995 - 00:00:00 CEST