Hello,

I've writing a script which will download some data from the web each day
and insert it into a table. I would like the script to be able to run
unsupervised, which means storing a password inside. Is there a way to
allow this sort of access and still have reasonable security?

I was thinking to create a 'script' user, which only has insert rights on
the specific table that it is supposed to populate. However, this
still allows someone to create new tables as 'script' and cause trouble in
other ways.

Am I trying to do the impossible, or is there a creative solution that I'm
just not seeing?

Thanks for any help,

Bill