Title: How to disable a user
since you are authenticating against an SQL database, you could just create a column in the table that has your authentication details called something like auth_dialup_flag as a boolean type (i don't know the exact Oracle syntax, i use Informix ;), and set it to 1 if the person is allowed to authenticate using the dialup, and 0 otherwise.  set your AuthBySql AuthSelect statement for the dialin authentication realm to something like 'select auth_password from authentication where auth_username = '%u' and auth_dialup_flag = 1'.  when you want to disable the dialin access for the user, all you have to do is a simple 'update authentication set auth_dialup_flag = 0 where auth_username = 'useryouwanttodisable';'.
 
hope this helps
---
Joel Michael
System Administrator
 
Diggy Internet Services
90 Petrie Terrace
Brisbane Qld 4000
Australia
 
Ph: +61 7 3367 3555
Fax: +61 7 3367 3544
Mob: 0401 039 462
----- Original Message -----
Sent: Friday, April 14, 2000 4:11 AM
Subject: (RADIATOR) How to disable a user

Other than changing the password or removing the user from the users list, is there any other way to temporarily disable a user?

What we're trying to do is sell dialup access as value added service in addition to our DSL service.  Therefore, we need to be able to disable dialup access on some customers while keeping their name/password so DSL will still work.

All user records will be stored in a remote Oracle db.

Any suggestion is greatly appreciated.

-Stephen

Reply via email to