Row level security

Hi,

I have an Access 2003 FE connected to SQL Server 2005 backend. I want to
identify each row of tables against each users, so I add a column 'Owner'
and have a default value to (suser_sname()).

I add a test record and found that (suser_sname()) return Domain\username.
Is there a way to store only username in the column?

SF


.

Relevant Pages

  • Re: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: logon failure
    ... MSSQLServer service after you change the username of administrator account. ... username for the SQL Server startup service account or the SQL Server Agent ... Microsoft SQL Server service account on the SQL Server host computer. ...
    (microsoft.public.windows.server.sbs)
  • Re: meta data & full text search
    ... There are more issues (transaction control, change control, audit of ... storing the files in a SQL Server table's column defined with an IMAGE ... if you store the files ... consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.inetserver.iis.security)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.win2000.security)