Kbase P33786: Which privileges for Oracle DB through Progress Dataserver application?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
Which privileges are required to view, add, modify, delete records in an Oracle DB through Progress DataServer application?
FACT(s) (Environment):
Oracle DataServer
FIX:
The minimal privileges required for Progress Oracle DataServer users to connect and add/modify/delete records in the tables are:
. CREATE SESSION
. SELECT privileges for the "sys.dual" system table.
. INSERT/SELECT/UPDATE/DELETE/EXECUTE on the application objects (tables, procedure, sequence,views)