Re: row level security without views

Hi
http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx



"Nikhil" <nikhilukidwe@xxxxxxxxx> wrote in message
news:1159253428.573628.105420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I want to implement row level security in SQL Server 2005 without
implementing views. The desired effect is firing a query on a table
like "select * from <tablename>" should return only rows which are
accessible to the logged in user. Which rows are accessible will be
decided using some data in another table. This table will have user
login name and one or more IDs associated with it. These IDs will be FK
in the table on which we fire select (or update/delete) query. I need
to device a solution such that the select query will return all rows
from the table which contain the ID that is assigned to the logged in
user. Is it possible in SQL Server 2005 without implmenting views on
each table?

Thanks in advance.
Nikhil.



.

Relevant Pages

  • RE: Has any Informix DBA had to do the following?
    ... I've never had that problem myself using IDS, granted then I was using c and esql/c for the connections so I knew every piece of code and had no thread issues. ... Disk access - busy disks but no predominant ... duration of the query. ... Has any Informix DBA had to do the following? ...
    (comp.databases.informix)
  • Re: Records from a Form to a Report
    ... query to use in a Combo Box, and let the user choose by clicking. ... I then use the INfunction to parse the IDs ... I can create a report based on the same query, ... Parameter queries are best reserved for manual execution. ...
    (comp.databases.ms-access)
  • RE: Help: Cleaning Messy Table Data
    ... My suggestion would be that you have a table of clean data with unique ids ... The second stage would be to run an update query each time to update ... duplicate names with different IDs, and duplicate IDs with duplicate names, ...
    (microsoft.public.access.queries)
  • Re: Filtering DB Call based on local Data
    ... Send the Ids as XML, parse it in a SP into a temp table then Join and return ... SQL Server will take care of the rest. ... single parameter to your query (it can be a stored procedure or dynamic ... specific to the order from the order table on a Sql Server Database ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Delete query date field pulling more than one month
    ... Query Q1 - will come up with the earliest date stamp for each month/year. ... FROM Q1 INNER JOIN tblMtdYtdAllRolling ON (Q1.MinOfDateEntered = ... Query Q3 - just deletes those IDs ... Q1 Dayand applying a criteria to that. ...
    (microsoft.public.access.queries)