Re: [PERFORM] security for row level but not based on Database user's

2006-04-25 Thread Richard Huxton
Ramasamy wrote: Hi Richard , Very good Day. Great information that you given to me. Great glad you think it's useful. Oh, don't forget to cc: the mailing-list - that's the convention around here. I will try in your idea. Here I am using SQL server 2000(Even I can use SQL Sever 2005 too if

Re: [PERFORM] security for row level but not based on Database user's

2006-04-25 Thread Richard Huxton
Friends wrote: Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, update delete and select. Well, the data access stuff is all manageab

[PERFORM] security for row level but not based on Database user's login

2006-04-24 Thread Friends
Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, update delete and select. Let me explain clearly For example think we are using asp/as