-
Trusted login problems
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|