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 |
|
nimesh69
Starting Member
30 Posts |
 Posted - 2000-12-12 : 00:28:34
|
| Hi all,I'm developing web apps using ASP/VB-COM/SQL6.5 since last 8months.To connect from COM to DB i've created only one user login. I insist on writing stored procs for any communicatin to DB.I recently subscribed to sqlteam and while going thru one of the article on "Using stored procedures (12/7/2000)" i thought to verify whether i'm doing something wrong.I'm using only ONE USER LOGIN to connect to db from COM which is a owner for all the objects required by application including tables, stored procs, user defined data types etc. Using this login i run all the stored procs which has DML st'ments.- Is it essential to create more than one db users?- Is it necessary to assign access rights for individual objects to this USER.The application with only one db user works absolutely fine, i just want to find out whether there is anything wrong in doing so.Please advise.Thanks,- Nimesh |
|
|
|
|
|
Confused about DB users