Hi,
Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.
Thanks!
Alejandrina 3 1394
Sure,
use the USER special register.
.....insert into audit_table (user_id) values (user)
/T
On Mar 2, 3:15 pm, "apattin" <apat...@gmail.comwrote:
Hi,
Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.
Thanks!
Alejandrina
THANKS! I'll give this a try.
Alejandrina
On Mar 2, 6:44 pm, "Tomas" <thal...@gmail.comwrote:
Sure,
use the USER special register.
....insert into audit_table (user_id) values (user)
/T
On Mar 2, 3:15 pm, "apattin" <apat...@gmail.comwrote:
Hi,
Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.
Thanks!
Alejandrina
On Mar 2, 8:15 pm, "apattin" <apat...@gmail.comwrote:
Hi,
Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.
Thanks!
Alejandrina
Besides the USER special register, you can use SQLID special register
available in DB2 for z/OS This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jesper Stocholm |
last post by:
I have implemented role-based security within my ASP.Net application.
However, it seems the role is not passed to the authentication ticket I
create.
I want to use it to display/hide some...
|
by: Dan Bart |
last post by:
I am using an application which is a modification of IBuySpy Portal.
It is using Forms authentication. Users login and their name is added
to
Context
Then I use:
...
|
by: Razak |
last post by:
Hi,
I have a class which basically do Impersonation in my web application. From
MS KB sample:-
++++++++++++++++++++code starts
Dim impersonationContext As...
|
by: Tom Nowak |
last post by:
I am writing a webapp in which a user is required to enter a login id and
password on a login form. I have forms authenticaion coded in my web.config.
Once the user is logged in, I want to use the...
|
by: Patrick Olurotimi Ige |
last post by:
How can i send LOGON_USER or User.Identity.Name to the Database?
I'm working on a survey which is intranet based with Windows
Authentication.
I can get the current user by calling LOGON_USER or...
| |
by: jakobsgaard |
last post by:
It is possible to Map a certificate to a Active Directory User Account from
DotNet?
Please provide an example.
Best regards,
Ejnar Jakobsgaard...
|
by: Abraham Andres Luna |
last post by:
hello everyone,
does anyone know why i can't access the
HttpContext.Current.User.Identity.Name property in a .cs file?
this is the index.aspx page:
<%@ Page Language="C#" %>
<script...
|
by: Daniel Knöpfel |
last post by:
Hello
On our asp.net 2.0 website we impersonate every request to the identity of
the user logged in. This works this way:
1. user logs in, providing username, password
2. user is authenticated...
|
by: =?Utf-8?B?Q2hhcmxlc0E=?= |
last post by:
hi folks,
I've got XP pro service pack 2 VS 2005 TSE with ASP.net 2.0 and C#
I'm doing an example from Stephen Walther's so far excellent book and he
has a whole load of stuff to add the...
|
by: =?Utf-8?B?QXZhRGV2?= |
last post by:
ASP.Net 2.
We are migrating to Windows 2008 64 bit Server with IIS 7 from Windows 2003
32 Bit with IIS 6. A few library classes we wrote uses impersonation in code
like explained in this...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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 ...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |