Database: DB2 AIX V8.*
Question: I want to be able to get the 'Client login ID' aka 'Execution
ID' (as opposed to the authid or application_id) for the current
connection within a stored procedure and without requiring SYSADM,
SYSCTRL, SYSMAINT, or SYSMON authority. This would be for audit
purposes as several different people can share an authid.
Obviously I can create a stored procedure to do the SQL below and then
grant execute to the users authid but I don't want to give them SYSADM,
SYSCTRL, SYSMAINT, or SYSMON authority which means the call will fail
for security reasons. <==tested
*************** *************** *************** *************** *************** *************** ********
I figured out how to do it using the snapshot (see below) but I don't
want to give the prod id sysmon authority.
Explanation: This query returns the Client login ID aka Execution ID
for the current connection to database dbname
Query:
SELECT EXECUTION_ID FROM TABLE(SNAPSHOT_ APPL_INFO('dbna me',-1))
AS SNAPSHOT_APPL_I NFO
WHERE APPL_ID = application_id( );
Authorized users can capture snapshots of monitor information for a DB2
instance by using snapshot table functions in SQL queries.
Prerequisites
You must have SYSADM, SYSCTRL, SYSMAINT, or SYSMON authority to capture
a database snapshot. 2 2355
ARK wrote: Database: DB2 AIX V8.*
Question: I want to be able to get the 'Client login ID' aka 'Execution ID' (as opposed to the authid or application_id) for the current connection within a stored procedure and without requiring SYSADM, SYSCTRL, SYSMAINT, or SYSMON authority. This would be for audit purposes as several different people can share an authid.
Does the CURRENT CLIENT_USERID special register give you what you want?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Indeed it does but it has to be set at the client level. I was hoping
to be able to use something without a the client special registers
being set. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: nao921 |
last post by:
Hi everyone,
I am currently involved in a project that involves a windows client
program written in delphi and a web application written in php. I
have made several php pages for the delphi program to do requests via
the http component from INDY. the problems I am having are:
1) the first request from delphi app to php web app is the
authenication. In which user sends username + password to the php app.
If authenication is valid, a...
|
by: Prince Kumar |
last post by:
I joined a company recently and they have a java program which hangs
(does nothing) after a while. This is no way consistent. It could
succeed quite a few times and can fail a few other times. There is no
consistency when it fails.
Could anyone here shed some light on how to debug/resolve the issue. I
guess IBM looked at the issue and were not able to pinpoint where the
issue is.
When the program hangs and when force the DB2...
|
by: Robert Wagner |
last post by:
I've created a page using VS.NET and page validator controls. The client
side validation works fine on IE, but does not even activate under
"alternate" browsers like Mozilla, Opera, etc. Why is this? I can't find any
differences on the pages produced, and Mozilla should be able to handle
everything IE can. How can I fix this?
|
by: Laurent Bugnion |
last post by:
Hi,
I am wondering what is the best way to find out which ASP.NET sessions
are still active.
Here is the reason: I have a custom control which can upload files. It
saves the files in a folder named after the SessionID. At Session_End, I
do some cleanup and delete the "session folder". However, if the PC is
rebooted before the session times out, the clean up never happens. So
what I wanted to do isL: In my CleanUp method, check all...
|
by: Ronald |
last post by:
I just started with dotnetnuke, and with a wrong login (wrong password
on a clean install i can crash the application pool from IIS.
(when i login with the right username/password information the site
works fine, i can do anything it is supposed to do)
I have the following setup:
-Windows 2003 x64 (fully patched, clean install)
-Dotnetframework 2.0.50727
-Dotnetnuke 4.3.1
| |
by: bartonc |
last post by:
With one small change to the view/control:
self.staticText3 = wx.StaticText(id=wxID_DBCONNECTDIALOGSTATICTEXT3,
label='ODBC Data Source Name', name='staticText3', parent=self, pos=wx.Point(240,
40), size=wx.Size(143, 16), style=0)
and some rework of the model:##from MySQLdb import *
from mx.ODBC.Windows import *
from time import time
class DBServer:
def __init__(self, master):
|
by: sandari |
last post by:
The following code (web.config in Visual Studio 2005) is supposed to redirect a user to the appropriate Form depending on their role.
However, regardless of the user's role, the only page displayed is the login page with the URL of the page the user was supposed to go to being displayed in the address bar.
A valid user is:
name "sandy"
password = san_mcd
role = Administrator
...
|
by: dm3281 |
last post by:
Hello --
I need to write an ASP.NET 2.0 application for our clients to use to login
and verify file transmissions. Each client will need their own logon, in
addition to a way to assign each user a unique customerid. All users
beloning to the same custeromid would see the same information on the
website.
Can I easily do this using membership services or must I use a combination
of membership services and profiles?
|
by: nja2222 |
last post by:
I would like to create a page for my clients to login and check for updates on their accounts. Then I would like to create a page where my employees can login and make updates, specifically new file uploads, to the clients accounts. I have seen similar sites everywhere, such as bank websites, USPS site, et cetera. What is
required to accomplish this? I'm trying to do this with the PHP, MySQL and Adobe CS3 Master collection's 'Dreamweaver CS3'
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |