Re: Logical File - How to Deny SQL Deletes??

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Jim,

I would take a look at triggers.

I am doubtfull, if the SQL server will actually use your specifically created 
LF.

In a triger you can check which programme object tries to do the record change. 
Of course, you have to find out, what programme name will be returned.

Just my 2 Euro cents.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 7-10-04 at 10:47 Trow, Jim wrote:

>I would like to provide our web server direct access to our AS/400
>production data via SQL server commands, but at the same time have that
>access controlled and restricted to read-only so that database integrity
>remains intact.   I've created a logical file based on the physical
>file(s) in question, and have tried numerous combinations of object
>authority changes on both the logical file and user profile used by the
>web server in order to test against SQL Deletes coming from the web
>server and nothing has worked.
>
>I'm surprised to have not found anything relating to this in the
>archives, and am wondering if I'm completely missing an easier or more
>accepted approach to my issue.  Does anyone have any ideas or suggestions?