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

create table AUTH_NET_USERS
(
PRIMARY KEY (network_auth_name),
network_auth_name VARCHAR2(63),
network_auth_password VARCHAR2(128),
session_timeout number (10),
idle_timeout number(10),
port_limit number(10),
tunnel_type number(10),
tunnel_medium_type number(10),
tunnel_client_end VARCHAR2(64),
tunnel_server_end VARCHAR2(64),
acct_tunnel_connection VARCHAR2(64),
service_type number(10),
framed_protocol number(10),
framed_ip_addr number(10),
framed_ip_netmask number(10),
framed_routing number(10),
filter_id VARCHAR(128),
framed_compression number(10),
);
COMMIT;
An SQL*Plus command, /opt/aaa/examples/oracle/create.sql, to execute
this statement, is distributed with the db_srv daemon.
Modifying the Table Structure
The following guidelines must be followed if you choose to modify the SQL statement
that creates the table or the create.sql script for your own unique requirements
(e.g., setting storage parameters):
• The table must be named AUTH_NET_USERS.
• You cannot add, remove, modify, or change the order of the predefined column
names.
• The table must be created in the database’s default SYSTEM table space
• You can only create the table in the default database or a database that has been
assigned an SID.
Supported Attributes
The column names in the AUTH_NET_USERS table correspond to attributes in a user
entry as follows:
Table 19-2 AUTH_NET_USERS Table
Corresponding RADIUS AttributeColumn Value
User-Name
network_auth_name
User Password
network_auth_password
254 Oracle Authentication (Supported Using SQL Access)