How to Prevent an OFSA User from Running "Update/Delete/Insert" Statements in SQL Talk

(Doc ID 2012995.1)

Last updated on MAY 27, 2015

Applies to:

Oracle Financial Data Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)

Goal

In Oracle Financial Services Applications (OFSA) 4.5, how can you update user privileges so users can only run "select" statements in SQL Talk?  You want to remove their ability to run update / delete / insert statements.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms