Re: hot to limit sqlldr ?
From: Noel <tbal_at_go2.pll-l>
Date: Wed, 13 Apr 2005 16:12:10 +0200
Message-ID: <d3j9da$53v$1_at_inews.gazeta.pl>
Date: Wed, 13 Apr 2005 16:12:10 +0200
Message-ID: <d3j9da$53v$1_at_inews.gazeta.pl>
Użytkownik Stefan napisał:
> Is there a way to limit or prevent sqlloding into a database for a user
> who has insert/update/delete privs?
>
> Do I have to write a logon trigger and kill the session of the
> applicaion name is sqlldr ?
>
> Any better way of doing this?
I really wonder of sense of that operation?
You let user insert rows, and now you want to prevent inserting, if user
uses a tool, which just helps to do it faster?
There is no big problem, to convert a file into table inserts and do
same job with sqlplus.
If you don't want user to use sqlldr just don't let him run executables.
That's my opinion.
-- NoelReceived on Wed Apr 13 2005 - 16:12:10 CEST