Implementing row level security in SQL 2000
Home > IT Answers > Security > Implementing row level security in SQL 2000
SQL Server Ask the Experts
2445 pts.
0
Q:
Implementing row level security in SQL 2000
Security, Implementation, SQL Server 2000, SQL Server security
Is there a way to implement row level security in SQL Server 2000?
ASKED: Jun 18 2008  7:27 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
No, not at the table level.

The closest thing would be to create a view for the use which only shows the rows that the user needs access to. Then give the user access to the view, not the table.
Last Answered: Jun 18 2008  8:23 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46810 pts.  |   Jun 18 2008  8:23PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0