Hello,

I am having the problem of preventing the users who use trusted login to connect to the SQl 6.5 database from accessing other users tables.

For e.g.
I have userA and userB. UserB has revoked all the privileges on a TABLE1 from public and granted only "SELECT" rights.

Now, if userB connects using sql authentication, he can only query the table1 bbut cannot update /delete rows.

Now if the same user connects using trusted login, he can update/delete
rows from userB.table1.


Is there a way to prevent this.