CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > general_asp.net.security Tags:
Item Type: NewsGroup Date Entered: 12/3/2007 1:09:36 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 21 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
mlg74
Asp.Net User
set permissions for user to only view certain rows of MS SQL database12/3/2007 1:09:36 AM

0/0

Hello, I'm using .NET login controls and have set up 2 roles, Admin and Basic User. I want to set some permissions for the Basic user to only be able to view certain rows of data from the MS Sql databse. For example, SELECT * FROM Orders WHERE BasicUser = SomeID. I need to know how to get the BasicUser ID from the login and match it up to the SomeID of the table I'm querying. thank you.

pkellner
Asp.Net User
Re: set permissions for user to only view certain rows of MS SQL database12/3/2007 6:22:20 AM

0/0

My solution for this is to use either "Filter" in the gridview, or better yet, create your own objectdatasource classes and supress the row at that point from being returned.

specifically, you can filter by userid with expressions.  here is a post I did on that.

http://peterkellner.net/2006/09/18/expressionbuilderidentity/


Peter Kellner
http://73rdstreet.com and blogging at
http://PeterKellner.net
MVP, ASP.NET
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Pro SQL Server 2005 Database Design and Optimization: Database Design and Optimization Authors: Louis Davidson, Kevin Kline, Kurt Windisch, Pages: 672, Published: 2006
BizTalk Server 2000 Developer's Guide for .Net: developer's guide for .Net Authors: Jason Storey, Scott Roberts, Robert Shimonski, Chris Farmer, Henk-Evert Sonder, Milton Todd, Pages: 512, Published: 2002
Microsoft Office Access 2003 Inside Out Authors: John Viescas, Pages: 1298, Published: 2003
ASP.NET 2.0 Website Programming: Problem-design-solution Authors: Marco Bellinaso, Pages: 576, Published: 2006
Microsoft Office XP Developer's Guide: version 2002 Authors: Microsoft Corporation, Microsoft Corporation, Pages: 769, Published: 2001
MCSA/MCSE/MCDBA: SQL Server 2000 Administration. Exam 70-228 Authors: Joseph L. Jorden, Rick Sawtell, Lance Mortensen, Pages: 608, Published: 2003
Access 2002 Enterprise Developer's Handbook: Enterprise Developer's Handbook Authors: Paul Litwin, Ken Getz, Mike Gunderloy, Pages: 952, Published: 2002
Microsoft SQL Server 2008: A Beginner's Guide Authors: Dusan Petkovic, Pages: 709, Published: 2008

Web:
Implementing row level permissions/security in SQL Server ... "SQL Server lets you configure permissions at server level, database ... see only those rows that have the 'LeadGeneratedBy' column set to 'SalesRep1'. ...
Permissions to view Stored Procedure Property - SQL Server - Trying to set output variable to row count result of SQL Execute Task .... To grant permissions to a user, database role, or application role, click Add. ...
Implementing Row- and Cell-Level Security in Classified Databases ... Most of a row might need to be visible a one set of users, while certain .... Evaluation of rights is based only on membership in SQL Server database roles. ...
Microsoft Solution Finder - View solution Row Level Security for Microsoft SQL Server - Data Nomad by PetroWEB, Inc. ... The extended database appears to only contain the rows to which the user has ...
Microsoft SQL Server 2000 System Catalog Table 13-8 contains information about MS SQL Server 2000 INFORMATION_SCHEMA views. ..... Returns information about user permissions in the current database. ...
Granting View Definition Permission to a User or Role Sep 29, 2008 ... In SQL Server 2005 by default users of a database that are only in the ... Here are two rows that show where the VIEW DEFINITION action has ...
InformIT: SQL Server Reference Guide > Database Objects: Views The user needs permissions to the view itself, and to columns of the tables that the ... the view would select rows of data where certain criteria are met. ...
MS SQL www.databasejournal.com/features/mssql/article.php/3379521 .... all permissions assigned to a specific user within a database with the following sample ...
How do you lock table (or view) fields from editing??? - MS SQL lock certain fields in the database from users so they can see them on the views and forms, but NOT be able to edit them. I've looked in BOL, MS SQL Server ...
DBAzine.com: Row Level Security – Part 1 Users who query the view will see only those rows that match their group code. ... Microsoft SQL Server 2005: the schema (a collection of database objects ...




Search This Site:










browser target support

problems cam up in the following areas during load: missing file

create users for dnn(3.0.8) outside iis

how can i associate a usercontrol with a master page

bin folder

multiple development servers started

dnn 2.0 - can it run on ms access alone ?

font size for menu

asp.net configuration menu option missing

what the heck does this mean?

dynamic css

parser error

how do i cancel a formview update?

beta 3 section or group name 'membership' already defined

visual studio magazine article

thread & timer in web application c#

cookies screwing my application - help.

ccproxy.exe

problem with metaweblogapi

asp.net vb in html body error

activedirectory authentication

question: increasing a module's version number

case insensitive passwords?

connection attempt failed

modify email column in contacts.ascx to use mailto

the better way to keep user id???

text comparision in xslt

changing security settings

gridview and hashtable

error when running asp.net configuration

 
All Times Are GMT