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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2009-02-16 : 09:11:06
|
| what is the best practice for creating users in sql 2000 for an application devlepment?1. should i create sql users then give the appropriate permissions on the tables and let them login using these accounts .2. or i will create a users table (loginname and pswrd) that will manage these accounts and the application will use one shared login and the security will be using the application |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-16 : 09:14:42
|
| 1.we usually created application roles for users and each user login will be associated to one of roles based on permissions required like reader,admin,superuser,...2.application will be using shared login based on roles created |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-02-16 : 11:28:57
|
| We usually use Windows based AD groups- and instead of assigning specific users to specific objects - we associate them with roles . Typically , we would have an Admin based roleand a general user role. There are also exceptions. Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2009-02-17 : 00:59:37
|
quote:
Originally posted by visakh16
1.we usually created application roles for users and each user login will be associated to one of roles based on permissions required like reader,admin,superuser,...2.application will be using shared login based on roles created
how the application will use shared login and also users login at the same time. isn't a shared login a single login shared to all users? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-17 : 02:54:53
|
| the shared login will be based on roles defined. each roles will have group of users assgned to it. |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2009-02-17 : 08:39:59
|
quote:
Originally posted by visakh16
the shared login will be based on roles defined. each roles will have group of users assgned to it.
the users in your case will be created in sql or just saved in user defined tables? and which is better?thanks for your patience |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-17 : 08:42:19
|
| our case list of users for each role will be in sql table |
|
|
|
|
|
|
best practice for managing users?