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 |
|
linux44
Starting Member
1 Post |
 Posted - 2009-03-28 : 13:45:37
|
| Hii am planning to design a database and have some problems with security stuff as follow:I have table called supplier and another table called invoice Table supplier:supplier id supplier addsupplier telsupplier passwordtable invoice:supplierid branchid ...the requirement is that each supplier should be able to access the invoice table and submit their invoice .what I have thought is ,that in supplier table i would have password colum which is defined to be unique.now what i am trying to achieve is that when the supplier enter their password ,the matched supplier id for that password from supplier table should be fined and once it found it ,it should insert it, into the supplier id in the invoice table.the supplier should not be able to modify the supplier id on invoice table by that i mean that,onced their password has been entered and the supplierid was found the supplier id should automatically be inserted into the invoice table and do not allow the supplier to change it.any help appreciate it |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-31 : 09:40:01
|
| This is form based authentication. Lots of examples on the web, e.g. http://www.jspruell.com/Tips/ASP-NET-Tip-1.htmYour website would use a single logon to SQL Server, but the application uses the user table to check user's permissions. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-31 : 15:25:22
|
| Would the supplier have only 1 invoice ? You might need to think about entering a unique id on the invoices table? or is the intention that the unique id is : supplierid and branchid ?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
define a password in the table