HP-UX AAA Server A.07.01 Administrator's Guide

insert into AUTH_NET_USERS values
(
'User-Name',
'User-Password',
Session-Timeout,
Idle-Timeout,
Port-Limit,
Tunnel-Type,
Tunnel-Medium-Type,
'Tunnel-Client-Endpoint',
'Tunnel-Server-Endpoint',
'Acct-Tunnel-Connection',
Service-Type,
Framed-Protocol,
Framed-IP-Address,
Framed-IP-Netmask,
Framed-Routing,
'Filter-Id',
Framed-Compression
);
commit;
Substitute attribute placeholders with an appropriate value to assign to the
corresponding column value. You can write a NULL value to any attribute, except
User-Name and Password. You can modify the /opt/aaa/examples/oracle/
insert.sqlcommand file included with db_srv, and then add all the users defined
in the file by typing START insert.sql at the SQL prompt.
• Remove user records with the following SQL commands:
delete from AUTH_NET_USERS where network_auth_name = 'User-Name';
commit;
Substitute the User-Name placeholder with the network_auth_name user record.
NOTE: This delete command line will remove all users that match User-Name. If you
have duplicate records keyed on the same network_auth_name value, all of the records
will be deleted.
You can use the /opt/aaa/examples/oracle/delete.sql command file included
with db_srv to clear user(s) from the table by typing START delete.sql at the SQL
prompt.
The Oracle table contains a data record for each user. Each row in the table represents
one user. Figure 19-2 shows a sample table and its relationship with the other database
structures.
252 Oracle Authentication (Supported Using SQL Access)