63,630 pts.
POSTED: Jun 18, 2008 8:23 PM (GMT)
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Implementing row level security in SQL 2000
Is there a way to implement row level security in SQL Server 2000?
ASKED:
Jun 18, 2008 7:27 PM GMT
UPDATED:
June 18, 2008 8:23:28 PM GMT
RELATED QUESTIONS
- row_number in sql 2000
- OLTP in SQL Server 2008
- How to implement row level security
- AR server
- Don't run the SQL Server Account as Local Administrator or member of the Administrator Group?
- retrieving run time records in SQL
- Eliminating duplicate rows in SQL Server 2000
- SQL Server 2000 log shipping through a firewall
- Windows 2000, Active Directory and Access DB
- Plans and Guidelines for a Web Application Project
Answer Wiki:
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.
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.
To see other answers submitted to the Answer Wiki View Answer History.
