>SQL Server does not natively support permissions at the row level. What about a view that references the USER_NAME() function and the WITH CHECK option?
>
>CREATE VIEW OnlyMyData
>AS
>SELECT *
>FROM table
>WHERE owner_column = USER_NAME()
>WITH CHECK OPTION
>
>Permissions should not be an issue if the view and table are owned by the same user.
>
>-Mike


Thanks for your reply

I have tested with the 'WITH CHECK OPTION' to but i had the same problem.

Extra information:
If have tried 3 way's

1 Using Visual FoxPro
I create a view from the view and when i select i got only the records
i want and i can update it.

2 Using ADO Connection to local DSN
I get the records i want and i can update it


3 Using ADO Connected with an REMOTE PROVIDER to DSN on the server.
I get the records i want. But when i try to update it I say i do not have
permisson on the table (that is correct. On that that table the user has only DRI rights. I user has full permissions on the view)

Kind regards