Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

DOA API Security

rbuserrbuser
edited December 2003 in End User
Hi all,

I have a question quite difficult to explain for my poor english...
Let's try:

D5 RH 7.02 Oracle 8.1.7 End user app.

Is it possibile to use a TOracleDataset with package call in it
(with a cursor variable)
instead of a regular sql "select .." statement?

I need this for security reason.
In this app we have tables which users access in this way ,
so they don't actually have granted select rights on the underlying tables.

It is a (very powerful) data access strategy called (in DOA demo) api mode

I would like to use it in our end user app but we use RB dictionary
filled with view created automatically.
I can't figure how to mix these views with some OracleDataset with
api data access....

Does anyone already had this problem?

Any tips/help will be very appreciated!
Thanks
Bye
Nicola

Comments

  • nardmoseleynardmoseley
    edited December 2003

    I am not familiar with this type of Oracle data access. However, to
    implement any type of custom data access you will need to modify the DADE
    plug-in for DOA. This code resides in daDOA.pas. Check out the DADE thread
    of the tech tips newsgroup for an overview of the architecture. The
    daDOA.pas code is straight forward, but let me know if you question about
    it.




    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.