Question

  Asked: Jun 18 2008   7:27 PM GMT
  Asked by: SQL Server Ask the Experts


Implementing row level security in SQL 2000


SQL Server 2000, Security, Implementation, SQL Server security

Is there a way to implement row level security in SQL Server 2000?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Security.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Jun 18 2008  8:23PM GMT

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