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

Article View: bu.localpostings

Article #192

#192

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

13 lines
964 bytes

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

I have an Access database that is front ending SQL Server
tables.  On the server I am creating views for each 
department.  The view will be read/write for users in that
department.  My problem I don't want to have 7 copies of the
database.  I had thought about linking the main table on start
but then I will still need to have multiple copies one for
each department. 

What is the best way to handle row level security?

Tom

Technical Details

Message-ID: <84ej9d$dq$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,328cb223a0eadce4,start
X-Google-Attributes: gid1552e4,public
From: Thomas Dauria <tdauria@bu.edu>
Subject: Security Access and SQL Server( comp.databases.ms-access)
Date: 1999/12/29
Message-ID: <84ej9d$dq$1@news1.bu.edu>
X-Deja-AN: 566360331
Organization: Boston University
X-Orig-Newsgrp: comp.databases.ms-access
User-Agent: tin/1.4-19991113 ("No Labels") (UNIX) (AIX/4-3)
Newsgroups: bu.localpostings