Table Permissions and Access97

[LearningSql]

Hello all. I am trying to figure out how to do this correctly.

I have set the permissions of 2 tables in SQLServer 2000 to "SELECT" only (for both public and 1 user using SQL Server Logon). I have set the USER permissions for SELECT only also. When an MSAccess97 application is created and ODBC linked to these tables I am able to UPDATE and INSERT data.

Can anybody provide me some guidance on what to look for to resolve this issue? I can provide more details but thought this question would spur specific questions.

Here are some rough answers to some possible questions:
- SQL Server Login for 1 user, User Permissions set to SELECT only
- Table Permissions set to Select Only for the 1 SQL Server Login

Thanks everybody in advance.
Pru

 

[tlbroadbent]

1) If public is granted permission, then it is not necessary to grant permission to individual users. All users are members of the public role.

2) Is the user a member of any other roles such as db_datawriter or db_owner? If the user is a member of some roles, insert and update permission is granted to the user through the role.

3) Are you cerain that the Access DB is connecting to SQL Server using the specified login and user? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.