Re: Row level and column level permissions.
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/24/04
- Next message: Gerry: "Lock Information"
- Previous message: SAMAY: "Re: Item cannot be found in the collection corresponding to the requested name or ordinal."
- In reply to: Arun: "Row level and column level permissions."
- Next in thread: Arun: "Re: Row level and column level permissions."
- Reply: Arun: "Re: Row level and column level permissions."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 May 2004 12:56:14 -0400
You could use roles and have different views based on the columns you want
each role to see?
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Arun" <ar_kumar@hotmail.com> wrote in message news:0C4D56B1-7357-45D1-8EF4-FAE3E8FD5A29@microsoft.com... > Dear All, > Any recommendations on best practices for implementing row level and column level permissions in an SQL server database. I did some googling and i could find some recommendations for implementing row level permissions.(I am aware that Yukon is going to have this feature built-in, am using SQL 2k). All of them were seemed to be specific to applications. > > Regarding column level security what concerns me is that, i want this to be applicable for my reporting tool(either crystal or sql reporting services). > > Thanks in advance. > > regards > Arun
- Next message: Gerry: "Lock Information"
- Previous message: SAMAY: "Re: Item cannot be found in the collection corresponding to the requested name or ordinal."
- In reply to: Arun: "Row level and column level permissions."
- Next in thread: Arun: "Re: Row level and column level permissions."
- Reply: Arun: "Re: Row level and column level permissions."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
