I am having an issue inserting a record into an Oracle table using some Perl code I wrote. The table contains a CLOB field. The user account that I am connecting to Oracle with has limited rights to the table. I had initially granted INSERT rights to the table, which I get back a message stating I have insufficient privileges. After a lot of searching, I found that when dealing with LOBs that I had to grant UPDATE privileges as well due to how DBI/DBD-Oracle handles LOBS. So I granted that privilege as well and still no luck. For some reason I have to grant SELECT privileges to the table as well as the INSERT and UPDATE privileges. Being that Perl is clear text code, I created this limited privilege account since the username and password are exposed. I would prefer to not grant SELECT privileges on the table if possible as an additional security precaution. Is there some way to insert CLOBs without granting SELECT privileges to the table?