Re: [External] : Direct DB Access for non IT users

ORDS is one of my ideas, we have it deployed but have only used it for a couple data calls besides APEX running on it. Reading is one part but a bigger part I am talking about here is these users updating and inserting data. ORDS could be a solution for that but without a front end it would be clunky. We don't have time to build an APEX front end for it.

On Wed, Dec 22, 2021 at 11:57 AM Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> Do deploy ORDS and build some views to surface the data with only select
> or read privs on the views.
>
>
>
> SQL Developer Web – they connect to the mid tier, but not the database,
> with their database credentials.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Jeff Chirco
> *Sent:* Wednesday, December 22, 2021 2:24 PM
> *To:* oracle-l-freelist <oracle-l_at_freelists.org>
> *Subject:* [External] : Direct DB Access for non IT users
>
>
>
> 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-l