In addition to Formspider security authorization, is it possible, before starting Formspider application, to have a different Oracle System Authorization connection via Tomcat of that specified datasource in application, and have it thru the session as primary DB connection. I don't wanna have FORMSPIDER or Application Datasource Schema USER in the DB session. Or, in other words, I don't wanna FORMSPIDER or a APPDS response from SELECT USER FROM DUAL.

asked 09 Jun '14, 04:54

ddjuric's gravatar image

accept rate: 0%

Hi Dusan,

What you want to achieve should be possible although currently we don't have a script to create this setup.

Formspider Middle Tier application communicates with the PL/SQL code in the database using a few procedures and functions. If access to these procedures&functions were granted to the Formspider Middle Tier through another schema which has the necessary grants and roles etc... everything would work properly.

Kind Regards,


answered 09 Jun '14, 06:04

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Thx. Are you planning to implement such functionality?

(09 Jun '14, 06:59) ddjuric

We are thinking about it.

(09 Jun '14, 07:00) Yalim Gerger ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 09 Jun '14, 04:54

Seen: 1,501 times

Last updated: 09 Jun '14, 07:00

© Copyright Gerger 2017