Subject | Default Values |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2002-08-16T10:10Z |
Hi
I have created a domain with the following values
CREATE DOMAIN DOM_CURRENT_USER
AS VARCHAR(15)
DEFAULT CURRENT_USER
NOT NULL
My question is, is the "Current_User" and the user I logged in with the
connection the same thing. Put differently, is the current_user variable
linked or dependant on the current connection to the database.
I ask because I use a sp to insert a record and I dont want to send the
current user as a sp parameter.
I would assume Current_user is transaction or connection based otherwise it
would not really be functional. However I just want to make sure, I dont
like assumptions.
Groete
Gerhardus
I have created a domain with the following values
CREATE DOMAIN DOM_CURRENT_USER
AS VARCHAR(15)
DEFAULT CURRENT_USER
NOT NULL
My question is, is the "Current_User" and the user I logged in with the
connection the same thing. Put differently, is the current_user variable
linked or dependant on the current connection to the database.
I ask because I use a sp to insert a record and I dont want to send the
current user as a sp parameter.
I would assume Current_user is transaction or connection based otherwise it
would not really be functional. However I just want to make sure, I dont
like assumptions.
Groete
Gerhardus