stuntwoman
asked on
Microsoft Access Security with SQL Server Server and Windows Authentication Groups problem
I have an Access 2003 front end linked to SQL Server 2005 tables.
Two groups of people are allowed access to the database, one group allowed to see certain tables/forms and the other group different tables/forms.
I am using Windows Authentication because these people have Windows groups already and have set up SQL Server Logins for them following the method in this question (https://www.experts-exchange.com/questions/22971000/Best-way-to-do-Access-SQL-Server-Security.html?sfQueryTermInfo=1+permiss+secur)
ie Use windows authentication
Use windows groups
Assign windows accounts to windows groups
Use group logins on SQL Server that correspond to the windows groups
Grant permissions to group logins
So my two Logins have select, update, delete, insert permissions on one of two different schemas and are denied these rights on the opposite one.
PROBLEM - it has made no difference!! as when they open the Access database they can still see all the linked tables and open them up etc. Does anyone know what I have done wrong - is there some VBA code I could use to see how the person is logging in and what permissions they have
Thanks
Two groups of people are allowed access to the database, one group allowed to see certain tables/forms and the other group different tables/forms.
I am using Windows Authentication because these people have Windows groups already and have set up SQL Server Logins for them following the method in this question (https://www.experts-exchange.com/questions/22971000/Best-way-to-do-Access-SQL-Server-Security.html?sfQueryTermInfo=1+permiss+secur)
ie Use windows authentication
Use windows groups
Assign windows accounts to windows groups
Use group logins on SQL Server that correspond to the windows groups
Grant permissions to group logins
So my two Logins have select, update, delete, insert permissions on one of two different schemas and are denied these rights on the opposite one.
PROBLEM - it has made no difference!! as when they open the Access database they can still see all the linked tables and open them up etc. Does anyone know what I have done wrong - is there some VBA code I could use to see how the person is logging in and what permissions they have
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You definitely need to relink to refresh the connection method.
ASKER