Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ODBC connection - permissions

1 view
Skip to first unread message

Rob

unread,
Feb 26, 2008, 7:55:27 AM2/26/08
to
I am doing the following in order to give some users access to selected
tables via MS-Access...

Create a Windows Security group in Windows called "ABC:"

Create a Windows authenticated SQL user called "ABC"

Assign individual users to the "ABC" group

Assign Select permissions on the 3 tables for user "ABC"

This works with one exception, I want to exclude the Schema and system
table....

Anyone know how to accomplish this ?


0 new messages