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

Thread View: bu.localpostings

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Thomas Dauria Wed, 29 Dec 1999 00:00

#192

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads