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.
>
> Let me explain clearly
>
> For example think we are using asp/asp.net website
Based on this, it appears you want an asp.net solution, so here is my canned
"dotnet" reply:
There was no way for you to know it (except maybe by browsing through some
of the previous questions before posting yours - always a recommended
practice) , but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-knowledgeable person here who
can answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.aspnet.
If you really want a classic ASP solution, post back to us and make it clear
which technology you are using.
>
> Eg:
>
> www.test.com
>
> So, here I need the row level security. For each and every table we
> need to check the corresponding user and executing the record produce
> lot of business logic problem for us.
> So after the user login we need automatically to set row level
> security for all the tables. Based on the user who login.
>
The simple answer is:
Do not allow the users to have direct access to the base tables. Use a
combination of stored procedures and views. Without more information about
your database structure I cannot provide a more specific answer.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
