Hello All,

I need some help...Actually i hav created users and roles in asp.net2.0 using website adminstration tool(WAT)..i hav created some tables in my database...i want to retrive the records from the table only entered by that particular user..i.e when user1 enters some two records n user2 enters some 3 records in same table...while retriving user1 has to get the 2 records entered by him only..how to do this....when iam searching for row level security i found solution like ....Create view on that table ,table must hav username column,which stores the name of the user when creating table records..But the thing is they hav created users from sqldatabase like this... EXEC sp_addlogin @loginame = 'SalesRep1', @passwd = 'pwd1', @defdb = 'SalesLeads'

As i am creating users from WAT,can i implement the same technique (create view .....) or i need to again create users from sql..?when i am creating users n roles from WAT tool ,they will be created automatically or wht...?i hav no idea as i am new to development...please help....

Thanks in Advance

anne