Re: Login name displayed on form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jonathan Smith (jasmith_at_spheniscidae.com)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 20:38:05 GMT

"dk" <dk@dk.hr> wrote in news:#yRJFP8cEHA.556@tk2msftngp13.phx.gbl:

> I trying to know the name of database user entered new record in table
> orders. ( FIELDS: OrderID,User,Date,ordertext)
> When I use =CurrentUser() as control source for field "User" I get the
> username of person logged to windows.( Admin).
> How can I set this value to any user logged to database ( entered in form
> USER).
>
>
> Thank You all for help.
>
>
>

This is the DEFAULT Response, until you implement ACCESS SECURITY.

Relevant Pages

  • Re: Newbie: Help with permissions
    ... Who owns the objects in the database? ... SELECT user_nameAS UserName, name ... The "simple" way to set up security (if you are allowing direct table ... I> think this is Windows Authentication. ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to add login
    ... > I am a new SQL Server admin. ... > since I am using Windows authentication. ... > problem deleting my old username, but went I went to add ...
    (microsoft.public.sqlserver.security)
  • Unable to add login
    ... I am a new SQL Server admin. ... since I am using Windows authentication. ... problem deleting my old username, but went I went to add ...
    (microsoft.public.sqlserver.security)
  • Re: sql express 2005 security
    ... You do not need to use a specific or predefined Windows username. ... permissions on the database. ... Regarding your question about "If they can login, they can view the data", ...
    (microsoft.public.sqlserver.security)
  • New Network User
    ... We've brought in a Temp to begin populating information for a new database. ... despite assigning her a username and password from within ... insufficient rights to access the file. ... if she logs into our Windows Network using my WINDOWS ID or another ...
    (microsoft.public.access.security)