Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record Permissions
Message
From
28/06/1999 12:49:37
 
 
To
21/06/1999 16:51:34
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00232196
Message ID:
00234825
Views:
22
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
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform