We've written a bunch of custom applications for various departments in our
company but unfortunately because of time constraints screens were never
developed to modify configuration type data, nor will time be given now.
Things like lookup data, new codes or assignment data. The developers get
those requests from the user and then write custom scripts to update the
tables. A proposal is out to give SQL Developer access to dedicated
individuals in the various departments to handle this type of work to
alleviate the workload on the developers. As a DBA I am not fond of these
people having direct database access to add and modify records. We are not
talking about sensitive data or the main application data. I feel it is
still a security issue, there is a chance they don't fully understand and
do it wrong or leave table locks open.
Do any of you have these issues and how do you handle them? Given end users
direct access?
Thanks,
Jeff
