Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rauken
Posting Yak Master
108 Posts |
 Posted - 2005-01-31 : 08:55:23
|
| I have an application developed in .net using both winforms and webforms. The client want to develop a new user role system for the application. They want to be able to set view or not view specific tables and read/write/change on field level on those tables the users can see. This must have been done so many times before, anyone who has a good way how to approach this problem? What I want is actually sql server's own database role properties. I have a extra table to identify the user type (admin, regular user etc)./Magnus |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 11:23:34
|
| Look up roles-SQL Server in books online and start with the overview section. Everything you need to know is right there.-ec |
 |
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2005-02-01 : 04:54:42
|
| Ok you might misunderstood me. Should I use the sql server's user roles or should I create my own user role tables?How often do people store users in sql server? I also want additional data for the user. |
|
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2005-02-01 : 06:21:45
|
| hi,Create your own table in sql server for managing roles and also implement "Role based authentication" in .NET. You can achieve this requirement easily.:) While we stop to think, we often miss our opportunity :) |
|
|
|
|
|
|
Creating a user role system for an applicaton