How we can restrict a single ROW in SQL server 2005?

Question

Post reply

How we can restrict a single ROW in SQL server 2005?

SQL-290976

SSC Enthusiast

Points: 189
More actions
August 17, 2006 at 11:49 pm

#61082

How we can achieve Row level access/security in SQL server 2005?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLZ SSChampion Points: 12872 More actions · Answer 1

Hi,

Can you be a bit more specific about what you need?

Karl
source control for SQL Server

SQL-290976 SSC Enthusiast Points: 189 More actions · Answer 2

How we can achieve Row level access/security in SQL server 2005?

Qaiser

SQLZ SSChampion Points: 12872 More actions · Answer 3

You cannot implement row level security in SQL Server 2005 (out of the box). You'd have to design and implement your own implementation of row level security using views or some other mechanism.

Here's a Microsoft White Paper on the subject:

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

or, an alternative:

http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm

Karl
source control for SQL Server