Security Access and SQL Server( comp.databases.ms-sqlserver)

Article View: bu.localpostings

Article #191

#191

From: Thomas Dauria
Date: Wed, 29 Dec 1999 00:00

14 lines
954 bytes

X-Orig-MsgId: <84ejjn$8n$2@news1.bu.edu>

I am front ending an SQL Server database using Access.  I have
views into my main table (people) that are filtered by 
departments.  I was thinking of programatically relinking the
main table on start up which would keep me from having to have
different version for each department, but I would still need
a different copy for each department.  

What's the best way to handle row level security?

Thanks,

Tom

Technical Details

Message-ID: <84ejjq$m5$1@news1.bu.edu>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1552e4,bbf2ad678ee446cb,start
X-Google-Attributes: gid1552e4,public
From: Thomas Dauria <tdauria@bu.edu>
Subject: Security Access and SQL Server( comp.databases.ms-sqlserver)
Date: 1999/12/29
Message-ID: <84ejjq$m5$1@news1.bu.edu>
X-Deja-AN: 566357411
Organization: Boston University
X-Orig-Newsgrp: comp.databases.ms-sqlserver
User-Agent: tin/1.4-19991113 ("No Labels") (UNIX) (AIX/4-3)
Newsgroups: bu.localpostings