on 06-11-2014 7:13 PM
Suppose I have a powerbuilder application myapp. there are many reports created with pb. There are 2 possible for pb report:
datawindow get data from stored procedure
datawindow get date with sql.
myapp use a specific login mylogin to connect to sybase ase.
then I want to track who and when the report running. how to implement it? any way without modify myapp code?
I tried with sybase audit, but myapp connect with mylogin. So anyone run myapp will be same login.
what's the solution for this case?
I guess there's no other solution than to modify your code and create a log every time the report is run.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We did this with Proxy Authorization. That's where you connect to the database with one user, but you can assume the authorization rights of another user for specific purposes.
So your app would have to connect with a user's individual ID, but then you'd issue 'set proxy myLogin' to give them rights to run the reports and access those database tables. If they ever connect outside your application (with Crystal Reports or some other 3rd party tool), they'd be connecting as their unique login and wouldn't have rights to the underlying database tables unless they also knew to issue the 'set proxy myLogin' command.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kent;
Here is what I do in my Transaction Object to associate the time in ASE to the application & user ...
SQLCA.LogId = "Chris.Pollach"
SQLCA.DBParm = "AppName='<myapp>',Host='<mypc>'"
HTH
Regards ... Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.