Re: Permission at the row level associated with user/login

From: "Uri Dimant" <urid@xxxxxxxxxxx>
Date: Sun, 17 Jun 2007 12:18:27 +0300

Juan
http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm

"Juan Dent" <juanjr@xxxxxxxxxxxxx> wrote in message
news:6D23828E-4AD9-4456-9E6E-B3836C1E0099@xxxxxxxxxxxxxxxx

Hi,

I have the following scenario:

I have a table X with 1000 rows. I want to allow select access to only 300
particular rows to a user/login while another user/login can see the other
700 (for example).

Is this granularity level possible in SQL Server 2005?

--
Thanks in advance,

Juan Dent, M.Sc.

Prev by Date: Re: Deny access to column in table
Next by Date: Re: Hoe to get Encrypted Password value varbinary field
Previous by thread: Re: Permission at the row level associated with user/login
Next by thread: MS SQL SERVER 2005 SSL ISSUE
Index(es):
- Date
- Thread

Relevant Pages

Re: Permission at the row level associated with user/login
... Juan Dent writes: ... particular rows to a user/login while another user/login can see the other ... Is this granularity level possible in SQL Server 2005? ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: question on windows auth
... utilizing benefits of connection pooling. ... use only one identity to connect to sql server. ... Now since the authentication is done by active directory ... You see I created a user/login in sql server with minimum ...
(microsoft.public.dotnet.framework.aspnet.security)