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 |
|
Faris2100
Starting Member
10 Posts |
 Posted - 2007-01-09 : 13:22:27
|
| Does any one know the best way to let users access an application. would be better to create logins in the database and use SQL server security model or just have the appliation connect to the database and then create the users and their permissions in tables so the application can control their access? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-09 : 13:28:30
|
| Both.First the overall security with SQL Server login account to restrict access to the database as such.And then depending on the type of application, set up a USERACCESS table where queries can lookup which users have access to which "modules".Peter LarssonHelsingborg, Sweden |
 |
|
|
Faris2100
Starting Member
10 Posts |
Posted - 2007-01-09 : 14:11:20
|
| thanx Peter.But when using tables in the applications to manage users and their permissions wouldn’t that be reinventing the wheel since SQL server has an entire security model which can do all that without having to write code for it. What do you think.thanks. |
|
|
|
|
|
|
Application access