General information
Forum:
Microsoft SQL Server
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only