Project Detail

Description

We need a WEB application that will allow our customers to access our SQL database that contains PINs used to access the Internet via WiFi local LANs. The basic characteristics of the system are:
1) User will logon into the database via the WEB using our existing WEB site (in Greek currently, plan to convert to English) www.skyfi.gr
2) Based on user's ID, he will be granted access rights to view certain tables of our billing server. Each table is a unique batch containing hundreds of usernames/passwords. Each username keeps track of usage and displays time used and time remaining
3) We need also an administration interface visible on the inside (intranet) of our network to allow us to create the user access details (ID and pass) and correlate the IDs with the appropriate batches (multiple batches per ID)

The system already supports one admin ID that can see all batches and all usernames/password in the database. All we need is a way to separate the batches to the corresponding customers and have an easy way to create new IDs and related them to new batches.
If you have experience with AAA services and authentication systems for prepaid Internet, this should be an easy task.