Direct DB Access for non IT users
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Wed, 22 Dec 2021 11:24:22 -0800
Message-ID: <CAKsxbLpbtoAJLL-1rufOJ2pLiPeb9m+LShbe1wLL5fOQje9zvA_at_mail.gmail.com>
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.
Date: Wed, 22 Dec 2021 11:24:22 -0800
Message-ID: <CAKsxbLpbtoAJLL-1rufOJ2pLiPeb9m+LShbe1wLL5fOQje9zvA_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 22 2021 - 20:24:22 CET