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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:12:06
|
Dan writes "Ok - this is a tough one. My whole being says that security is an software infrastructure service (ie a service as provided by the operating system, DB, or other low level service); however - I need my application to be tightly coupled with security such that app users have the ability to create users and groups themselves. I would rather not clutter up an NT Domain with user and groups especially when these users go into the 1000s or 100000s and groups into the 1000s. I would also not elect to create users and groups in the SQL server or in a directory service. Why? Because I need to assign user and group privileges down at the record level. Everyone is familiar with the File System and ACLs - well that is what I want to achieve at the database record level.
Nirvana would be authenticating the user and generating an authorization token to use when performing SQL queries. For example, User 10 is in groups 110,202 and 1001, and I want to pull back re |
|
|
|
|
|
Security, Security, Security...for SQL 7