Gossamer Forum
Home : Products : DBMan SQL : Pre Sales :

User Authentication / Restrictions

Quote Reply
User Authentication / Restrictions
I'm working on a simple Sales Leads Contact database and am wondering if I can accomplish the following with DBMan SQL.

a) There are a couple of users in the company, all of whom will be entering new Sales Leads into the database. Users need to be able to add / edit / delete each others records.
b) One of the fields in the primary table containing contact info is "SalesRepID," which will be joined to another table (SalesRep) for look-up purposes. A sales rep is manually assigned (linked) to a record when it is entered.

So far, easy enough. However, they would like their Sales Reps to be able to login to the system, but ONLY see records that have been assigned to them. Can I accomplish this? If so, how would I create this kind of restriction? And where would I store the SalesRep login details? In the standard Users table, or by using extra fields in the SalesRep table I'm creating for lookup purposes?

Thanks -
Subject Author Views Date
Thread User Authentication / Restrictions RickG 2994 Jun 13, 2003, 4:29 AM
Post Re: [RickG] User Authentication / Restrictions
604 2935 Jun 13, 2003, 12:14 PM