Re: Column level security
From: Cindy Gross (cgross@online.microsoft.com)
Date: 12/17/02
- Next message: Alvin Zhao[MSFT]: "RE: Can login permissions change on their own?"
- Previous message: Cindy Gross: "RE: SQL & IIS Authentication"
- In reply to: Kalen Delaney: "Re: Column level security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: cgross@online.microsoft.com (Cindy Gross (MS)) Date: Tue, 17 Dec 2002 02:45:44 GMT
As Kalen mentioned earlier, the way to do what you want is:
"You can create a view containing just the columns which the user may supply
values to, and give the user permission to insert into the view. All the
columns which aren't in the view need to have defaults already defined, or
to allow NULLs."
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Alvin Zhao[MSFT]: "RE: Can login permissions change on their own?"
- Previous message: Cindy Gross: "RE: SQL & IIS Authentication"
- In reply to: Kalen Delaney: "Re: Column level security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
