Hi Mike,

A possibility, if I understand you correctly, is to create a role for the
user with the update, delete, insert privs in the role; assign the role to
the user, but not as a default role. In the sql script you could use the
set role name_of_role command to turn the role on. One drawback I see
with this, is that the user may be able to set this role as default.

Just a thought.

J



Oracle LazyDBA home page