AppendixG ODBC Import Definitions
An Example accountActions Table
G-36
Cisco Secure ACS 3.0 for Windows 2000/NT Servers User Guide
78-13751-01, Version 3.0
An Example accountActions TableTabl e G-11 prese nts an example of an accountActions table that contains some of
the action codes described in Action Codes, page G-5. First user “fred” is created,
along with his passwords, including a TACACS_ Enable password with privilege
level 10. Fred is assigned to “Group 2.” His account expires after December 31,
1999, or after 10 incorrect authentication attempts. Attributes for Group 2 include
Time-of-Day/Day-of-Week restrictions, token caching, and some RADIUS
attributes.
Note This example omits several columns that should appear in any accountActions
table. The omitted columns are Sequence ID (SI), Priority (P), DateTime (DT),
and MessageNo (MN).
TableG-11 Example accountActions Table
Action
User
name
(UN)
Group
Name
(GN)
Value
Name
(VN) Value1
(V1) Value2
(V2) Value3
(V3) AppId
(AI)
100 fred —— fred ———
102 fred —— freds_password ———
103 fred —— freds_chap_
password ———
104 fred —— freds_outbound_
password ———
105 fred —— freds_enable_
password 10 ——
106 fred Group 2 —— ———
150 fred —— 123.123.123.123 ———
151 fred —— 01832-123900 ———
109 fred —— PASS_STATUS_
NEVER ———
110 fred —— PASS_STATUS_
WRONG ———