• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Can we encrypt oracle trace generated from powerbuilder

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Can we encrypt oracle trace generated from powerbuilder

  1. How-to
0
Votes
Undo
  1. Kumar Rahul
    Kumar Rahul
  2. PowerBuilder
  3. Sunday, 7 April 2024 15:02 PM UTC

Powerbuilder produces oracle trace when we set -[SQLCA.DBMS = "TRACE ORA Oracle"]. This produces traces in the plain text format and any one can read this. It contains name of processes that are used to execute any process in application. By reading this trace anyone can track and get sensitive information. From application we can disable the trace for application user.

There are third party tools which can attach to the process and see the trace. 

 

1. Is there a way to encrypt this trace, so that even if someone has access to, cannot infer anything from this.?

2. Can we detect if any process is attached to the application, so that application will shut down if it finds any process attached to it.

PB Support for Datetime and Datetime2 in SQL Serve...
Theme in specific window / Object
Responses (3)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 8 April 2024 14:47 PM UTC
  2. PowerBuilder
  3. # 1

This sounds like a 'what if' that would never happen in real life. As long as the app doesn't turn on trace and you have good anti-virus software, you should have no problem.

Comment
There are no comments made yet.
Kumar Rahul
Kumar Rahul Accepted Answer Pending Moderation
  1. Monday, 8 April 2024 05:26 AM UTC
  2. PowerBuilder
  3. # 2

Thank you for providing reference to this Process explorer app. 

This gives details of all the process running on the system, however I would like to find out if other program is looking at the application process.

e.g. Application is started as process A, another app started as Process B is programmatically attached to process A and can read the network from Process A. From my application(Process A), I would like to find out if any other process is looking at Process A.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 8 April 2024 13:58 PM UTC
Hi Kumar;

That a tough one because I can run a PB app as a separate process that is not attached to another process yet monitor everything it's going & resources it's consuming. So I'm not sure what you can do to stop another process (attached or not) from monitoring your app

Mainframes solved this eons ago by using "protect keys". Each App EXE runs in it's own protect key. Any other process that tries to monitor you is blocked by the O/S as the protect keys are not the same. MS-Windows though does not support this paradigm (unfortunately).

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 7 April 2024 22:35 PM UTC
  2. PowerBuilder
  3. # 3

Hi Kumar;

A#1 - yes & no. Normally, the trace is always in plain text but you can have the PB App encrypt it using the Crypter object class. 

https://docs.appeon.com/pb2022r2/objects_and_controls/CrypterObject_object.html

A#2: yes it think so. Check out my process explorer PB App for how to locate any process. 

https://chrispollach.blogspot.com/2024/02/explorer.html

HTH 

Regards ... Chris 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.