System and method for detecting unused accounts in a distributed directory service

Information

  • Patent Application
  • 20080046576
  • Publication Number
    20080046576
  • Date Filed
    August 16, 2007
    17 years ago
  • Date Published
    February 21, 2008
    16 years ago
Abstract
A distributed information processing system in an enterprise computer network comprising a collection of servers providing a directory service and a directory-enabled access control system is augmented with the ability to detect user accounts in the directory service for users who have not recently authenticated to an application that uses the directory-enabled access control system.
Description

DRAWINGS—FIGURES


FIG. 1 is a diagram illustrating the components of the system for detecting unused accounts in a distributed directory service.



FIG. 2 is a diagram illustrating the prior art components of a directory-enabled access control system.



FIG. 3A, FIG. 3B, and FIG. 3C are a flowchart that illustrates the algorithm used in a log parsing agent component.



FIG. 4A and FIG. 4B are a diagram that illustrates the contents of a LPA database component.



FIG. 5A, FIG. 5B and FIG. 5C are a flowchart that illustrates the algorithm used in an unused account detection component.



FIG. 6 is a diagram that illustrates the contents of a UAD database component.



FIG. 7 is a diagram illustrating the typical components of a server computer.



FIG. 8 is a diagram illustrating the typical components of an enterprise network and computer systems of a directory-enabled access control system deployment that spans multiple physical locations.





REFERENCE NUMERALS






    • 10 client application component


    • 12 access control component


    • 14 directory server component


    • 16 directory server component


    • 18 LPA database component


    • 20 log parsing agent component


    • 22 log parsing agent component


    • 24 LPA database component


    • 26 unused account detection component


    • 28 UAD database component


    • 30 user


    • 32 administrator


    • 40 client application component


    • 42 access control component


    • 44 directory server component


    • 46 directory server component


    • 130 authenticator table


    • 132 bind pattern table


    • 134 search pattern table


    • 136 element set table


    • 138 log status table


    • 240 identity table


    • 242 agent table


    • 300 server computer


    • 302 CPU


    • 304 hard disk interface


    • 306 system bus


    • 308 BIOS ROM


    • 310 hard disk


    • 312 operating system software and state stored on hard disk


    • 314 application software and state stored on hard disk


    • 316 RAM


    • 318 operating system software and state in RAM


    • 320 application software and state in memory


    • 322 network interface


    • 324 LAN switch


    • 400 network switch


    • 402 administrator workstation computer


    • 404 directory server computer


    • 406 UAD server computer


    • 408 time server computer


    • 410 access server computer


    • 412 router


    • 414 client computer


    • 416 directory proxy server computer


    • 418 WAN


    • 420 router


    • 422 network switch


    • 424 directory server computer





DETAILED DESCRIPTION

The invention comprises the following components:

    • a client application component (10),
    • an access control component (12),
    • a directory proxy server component (14),
    • a directory server component (16),
    • a log parsing agent component (20, 22),
    • an LPA database component (18, 24),
    • an unused account detection component (26), and
    • a UAD database component (28).


The client application component (10) is a software component that relies upon an access control component (12) to assist in the process of authenticating the users of the client application. A user will typically begin the authentication process to a client application by providing their userid and an authentication credential, such as their password. The client application component will provide the userid and credential to the access control component via an application programming interface (API), a system call, or a network protocol. The access control component will respond to the client application component with an indication of whether the user has been successfully authenticated.


The access control component (12) is a software component that provides an authentication and access control service to the client application component (10). The access control component will establish connections to one or more directory server (16) or directory proxy server (14) components. In order to authenticate a user who is accessing a client application, the access control component will submit one or more DAP or LDAP requests over these connections, in which the request locates a directory entry for the user, and either validates the user's authentication credential against that directory entry, or retrieves the stored authentication credential from the directory entry.


The directory proxy server component (14) is a software component that forwards requests it receives from the access control component to one or more directory servers for further processing. When the directory proxy server forwards a request to a directory server or receives a response from a directory server, the directory proxy server will write the parameters of the request or response in its access log. The directory proxy server is used in the situation of directory servers which do not generate an access log of search or bind requests. In this situation, a directory proxy server can be placed between the access control and the directory server, and the directory proxy server will be configured to generate the access log.


The directory server component (16) is a software component that implements the server side of a directory access protocol, such as DAP or LDAP. The directory server component maintains a directory information tree of one or more directory entries. Each user of a client application is represented by a directory entry in the directory information tree.


The log parsing agent component (20, 22) is a software component that collects and processes access log information. A log parsing agent is installed on each server computer where a directory server or directory proxy server is installed, to collect access log information from that directory server or directory proxy server. The log parsing agent retrieves patterns from the LPA database (18, 24), which is configured with a set of patterns that indicate the forms of bind and search operations generated by the access control component when it authenticates a user. Each log parsing agent has access to a pattern for each directory-enabled access control component present in the deployment that relies upon the directory server or directory proxy server whose log is monitored by that log parsing agent. The behavior of the log parsing agent component is illustrated by the flowchart of FIG. 3A, FIG. 3B and FIG. 3C.


The LPA database component (18, 24) is a software component that maintains the persistent state of the log parsing agent component. The LPA database can be implemented as a relational database, which comprises five tables: the authenticator table (130), the bind pattern table (132), the search pattern table (134), the element set table (136) and the log status table (138). The structure of these tables is illustrated by the diagrams of FIG. 4A and FIG. 4B.


There is one row in the authenticator table (130) for each access control component (12) in the deployment. Rows in this table are created by the administrator. The primary key of this table is the AUTHENTICATOR ID column. The columns of this table are:

    • AUTHENTICATOR ID: a unique identifier for the access control component,
    • SOURCE ADDRESS: the network address, such as an Internet Protocol (IP) address of the server computer where the access control component is installed,
    • SOFTWARE VERSION: an identifier for the software package and version which implements the access control component, and
    • STATUS: an indication of the configured status of the access control component.


Examples of values used in the STATUS column in rows in the authenticator table (130) include “disabled”, to indicate that the access control component has been temporarily disabled, and “deleted”, to indicate that the access control component has been permanently disabled. A NULL value in the STATUS column indicates that access control component is active.


There is one row in the bind pattern table (132) for each access control component in the deployment which uses a bind request to authenticate a client. Rows in this table are created by the administrator. The primary key of this table is the PATTERN ID column. The columns of this table are:

    • PATTERN ID: a unique identifier for the pattern,
    • SOURCE ADDRESS: either the network address, such as an Internet Protocol (IP) address of the server computer where the access control component using this pattern is installed, or NULL if there are multiple server computers on which an access control component using this pattern is installed,
    • BASE DN: a distinguished name of the subtree of the directory information tree in which the entries for users are located,
    • MATCH TYPE: the attribute type of the attribute value assertion in the least significant component of the distinguished name supplied in the bind request, for which the assertion value is the userid of the user,
    • STATUS: an indication of the configured status of this pattern; a NULL value indicates this pattern is active, and
    • AUTHENTICATOR ID: a unique identifier for the access control component.


There is one row in the search pattern table (134) for each access control component in the deployment which uses a search request to authenticate a client. Rows in this table are created by the administrator. The primary key of this table is the PATTERN ID column. The columns of this table are:

    • PATTERN ID: a unique identifier for the pattern,
    • SOURCE ADDRESS: either the network address, such as an Internet Protocol (IP) address of the server computer where the access control component using this pattern is installed, or NULL if there are multiple server computers on which an access control component using this pattern is installed,
    • BIND DN: either a distinguished name with which the access control component authenticates itself to the directory before performing search operations, or NULL if there are multiple access control components using this pattern,
    • SEARCH BASE: either a distinguished name of the baseObject field of the search request sent by the access control component if the search scope is “singleLevel” or “wholeSubtree”, or NULL if the search scope is “baseObject”,
    • SEARCH SCOPE: the search scope in the search request sent by the access control component, one of “baseObject”, “singleLevel” or “wholeSubtree”,
    • FILTER PATTERN: a regular expression matching a string encoding the search filter sent by the access control component,
    • MATCH TYPE: the attribute type in an equality match filter in the search filter sent by the access control component, in which the assertion value is the user id of the user being authenticated,
    • REQUESTED TYPES: either a set of attribute types in the attributes field of the search request sent by the access control component, or NULL if the attributes field is not relevant to matching the pattern,
    • STATUS: an indication of the configured status of this pattern: a NULL value indicates this pattern is active, and
    • AUTHENTICATOR ID: a unique identifier for the access control component.


There is one row in the element set table (136) for each record to be transferred to the unused account detection component. Rows are added to and removed from this table by the log parsing agent component. The primary key of this table is the ELEMENT ID column. The columns of this table are:

    • ELEMENT ID: a unique identifier for the element,
    • DATE: the date and time of the log record,
    • OPERATION: an indication of the directory operation represented by this element,
    • PATTERN ID: either the unique identifier of the pattern which matched the log record, or NULL if a pattern was not matched, and
    • TARGET: the userid of the affected user.


There is one row in the log status table (138). This row is updated by the log parsing agent component. The columns of this table are:

    • PARSE DATE: the date and time of the last parse of the directory server or directory proxy server access log, and
    • CHECKPOINT: the index into the directory server or directory proxy server access log of the last record read by the log parsing agent component.


The unused account detection component (26) is a software component that receives element sets from one or more log parsing agent components (20, 22) via a network connection. The network connection comprises an application layer protocol exchange, carried within a secure sockets layer session layer protocol exchange which provides encryption, such as the secure sockets layer protocol Transport Layer Security (TLS) protocol described in the document “The Transport Layer Security (TLS) Protocol Version 1.1” by T. Dierks et al of April 2006, carried within the Transmission Control Protocol (TCP) on an Internet Protocol (IP)-based computer network. The unused account detection component updates the UAD database (28) identity and agent tables. The unused account detection component is configured with a time interval for user inactivity, for example 30 days, and a time interval for log parsing agent contact, such as one day. The behavior of this component is illustrated by the flowchart of FIG. 5A, FIG. 5B and FIG. 5C.


The UAD database component (28) is a software component that maintains the persistent state of the unused account detection component. The UAD database can be implemented as a relational database, which comprises two tables: the identity table (240) and the agent table (242). The structure of these tables is illustrated by the diagram of FIG. 6.


There is one row in the identity table (240) for each user that accesses the client application component. The primary key of this table is the USER ID column. The columns of this table are:

    • USER ID: a unique identifier for the user,
    • USER NAME: the name of the user,
    • LAST LOGIN ATTEMPT DATE: the date and time of the most recent login attempt by that user as known by the unused account detection component, and
    • STATUS: an indication of the status of the user, one of NULL for an active user account, “inactive” for an inactive user account, “disabled” for an account that has been temporarily disabled by the administrator, and “deleted” for an account that has been deleted by the administrator.


Initially, rows are added to the identity table (240) for each user. In each row, the initial value of the LAST LOGIN ATTEMPT DATE column is set to the current date and time, and the value of the STATUS column is set to NULL.


There is one row in the agent table (242) for each log parsing agent. The primary key of this table is the AGENT ID column. The columns of this table are:

    • AGENT ID: a unique identifier for the log parsing agent,
    • LAST CONTACT DATE: the date and time of the last contact received from the log paring agent, and
    • STATUS: an indication of the status of the log parsing agent.


The processing components of this invention can be implemented as software running on computer systems on an enterprise computer network.



FIG. 8 illustrates an example enterprise computer network. At one site, an administrator workstation computer (402), a directory server computer (404), a UAD server computer (406), a time server computer (408), an access server computer (410), a client computer (414), a directory proxy server computer (416) and a router (412) are attached to a network switch (400). The router (412) at that site connects to another router (420) at a different site via a wide area network (418). At that other site, the router (420) and a directory server computer (424) are connected to a network switch (422). In this enterprise computer network, the client application (10) can be implemented as software running on the client computer (414), the access control component (12) can be implemented as software running on an access server computer (410), the directory proxy server (14) can be implemented as software running on a directory proxy server computer (416), the directory server component (16) can be implemented as software running on the directory server computers (404 and 424), the LPA database (18) and log parsing agent (20) can be implemented as software running on a directory proxy server computer and directory server computers, and the unused account detection component (26) and UAD database (28) can be implemented as software running on the UAD server computer (406). The time server computer (408) communicates with the other computers in the enterprise network using a protocol such as the Network Time Protocol (NTP) to maintain time synchronization.



FIG. 7 illustrates the typical components of a server computer (300). Components of the computer include a CPU (302) a system bus (306), a hard disk interface (304), a hard disk (310), a BIOS ROM (308), random access memory (316), and a network interface (322). The network interface connects the computer to a local area network switch (324). The hard disk (310) stores the software and the persistent state of the operating system (312) and applications (314) installed on that computer. The random access memory (316) holds the executing software and transient state of the operating system (318) and application processes (320).


Operations

The log filtering agent component comprises a single thread of execution. At step 62, the thread will create an empty element set by initializing the element set table (136). At step 64, the thread will read the log checkpoint from the log status table (138) and compare this checkpoint with the access log of the directory server or directory proxy server. At step 68, the thread will test whether there are unread access log records which the log parsing agent has not yet processed. If there are no unprocessed log records, then at step 70 the thread will wait for log updates from the directory server or directory proxy server, or until a timeout period is reached.


At step 72, the thread will traverse each log record in the log of the directory server or directory proxy server that has not yet been handled by the log parsing agent. At step 74, the thread will parse the record from the log. At step 80, the thread will test whether the log record is a bind operation or a search operation. If it is a bind operation, then the thread will search the bind pattern table (132) for a row in which: the value of the SOURCE ADDRESS column, if not NULL, matches the network address of the directory access protocol client, the value of the BASE DN column is a suffix of the distinguished name of the request, the value of the MATCH TYPE column matches an attribute type in the least significant relative distinguished name of the bind request, and the value of the STATUS column is NULL. If it is a search operation, then the thread will search the search pattern table (134) for a row in which: the value of the SOURCE ADDRESS column, if not NULL, matches the network address of the directory access protocol client, the value of the BIND DN, if not NULL, matches the distinguished name by which the client authenticated to the directory server, the value of the SEARCH BASE column, if not NULL, matches the baseObject field of the search request, the value of the SEARCH SCOPE column matches the scope field of the search request, the value of the FILTER PATTERN column matches the filter of the search request, the value of the MATCH TYPE column is an attribute type of an equality filter in the filter in the search request, the value of the REQUESTED TYPES column, if not NULL, matches the value of the attributes field of the search request, and the value of the STATUS column is NULL. At step 84, the thread will test whether one or more rows were found in either the bind pattern table or the search pattern table. If no search was performed or no rows were found, then at step 86 the thread will test whether the operation is a delete operation or an operation, such as a modify, which changes the state of the user. If so, then the thread will continue at step 90. If no search was performed, no rows were found, and the operation is not a delete operation or does not change the state of the user, then the thread will continue at step 92. If the search was performed and one or more rows were found, then at step 88, the thread will process record by pattern to extract the userid of the user being authenticated. At step 90, the thread will add an element to the element set table (136) for the record. After the records have been handled, the thread will continue at step 100.


At step 100, the thread will test whether it has a connection to the unused account detection component. If it does not have a connection, then at step 102 the thread will establish a connection to the unused account detection component. If the connection establishment failed, then at step 106 the thread will report an error, and continue to step 66. At step 108, the thread will send the element set to the unused account detection component over the connection. At step 110, the thread will test whether the unused account detection component successfully received the element set. If the unused account detection component did not successfully receive the element set, then at step 112 the thread will report an error; at step 114 the thread will close the connection, and the thread will continue at step 66. Otherwise, at step 116, the thread will close the connection, clear the element set, and save the log state to the log status table (138). The thread will then continue at step 66.


The unused account detection component (26) has a single thread of execution. At step 152, the thread will set the initial value of the LAST LOGIN ATTEMPT DATE column in each row of the identity table (240) to the current date and time, and set the initial value of the LAST CONTACT DATE column in each row of the agent table (242) to the current date and time. At step 156, the thread will wait, either until a connection is attempted from a log parsing agent, or until a timer event occurs. The timer is set to the log parsing agent contact interval. If a timer event occurred, then the thread will continue at step 190. Otherwise, at step 160, the thread will receive an element set from a log parsing agent over the connection, and then close the connection. If the element set transfer failed, then the thread will loop back to step 156. Otherwise, at step 164 the thread will set the value in the LAST CONTACT DATE column for the row in the agent table (242) for the log parsing agent to the current date and time. At step 166, the thread will traverse the elements in the element set. At step 168, the thread will parse the element, extract the userid of the user from the element, and search the identity table (240) for a row in which that userid matches a value of the USER ID column. At step 180, the thread will test whether a row was found. If a row is found, then at step 182 the thread will test whether the date and time in the value of the LAST LOGIN ATTEMPT DATE in the row is more recent than the date in the element. If an identity is found and the date and time in the row is not more recent than the date and time in the element, then at step 184, the thread will set the value of the LAST LOGIN ATTEMPT DATE column of the row in the identity table to the date and time of the element. At step 186, the thread will loop back to step 168 until all elements of the element set have been processed.


At step 190, the thread will search the agent table (242) for rows in which the value of the STATUS column is NULL. If one or more rows have a value in the LAST CONTACT DATE that is older than the configured log parsing agent interval, then the thread will loop back to step 156. Otherwise, at step 194 the thread will traverse the log parsing agents represented by the rows of the agent table (242). At step 210, the thread will compute the time difference between the current date and time and the last contact date and time of the agent from the value of the LAST CONTACT DATE column. After all the rows for the log parsing agents have been traversed, at step 214, the thread will select the largest of the time differences calculated, add the user inactivity time interval to this largest time difference to form a sum, and set an inactivity date and time to be this sum subtracted from the current date and time. At step 216, the thread will search the identity table (240) for rows in which the value of the STATUS column is NULL. At step 218, the thread will traverse each user record in the identity table. At step 220, the thread will compare the user's last login date and time from the value of the LAST LOGIN ATTEMPT DATE column with the inactivity date and time. At step 224, the thread will test whether the value of the LAST LOGIN ATTEMPT DATE column is earlier than the inactivity date and time. If the value is earlier, then at step 226 the thread will update the row in the identity table by setting the value of the STATUS column to “inactive”. At step 228, the thread will loop back until each record has been processed. The thread will then continue at step 154.


CONCLUSIONS

Many different embodiments of this invention may be constructed without departing from the scope of this invention. While this invention is described with reference to various implementations and exploitations, and in particular with respect to systems for monitoring the last login times of users with accounts in a distributed directory service, it will be understood that these embodiments are illustrative and that the scope of the invention is not limited to them.

Claims
  • 1. A method of determining whether a user account has been recently used in authentication to a client application in a distributed system deployment, said method comprising: (a) transmitting over a directory access protocol a request from an access control component to a directory server,(b) logging by said directory server of a username parameter of said request identifying said user account and an access time as an element in an access log,(c) transmitting over an application protocol said element from a log parsing agent component to an unused account detection component,(d) updating an access time of a record corresponding to said user account in a database attached to said unused account detection component with said access time from said element transmitted from said log parsing agent, and(e) comparing said access time of said record with a minimum inactivity time.
  • 2. The method of claim 1, wherein said directory access protocol is a lightweight directory access protocol.
  • 3. The method of claim 1, wherein said request is a bind request.
  • 4. The method of claim 1, wherein said request is a search request.
  • 5. The method of claim 1, wherein said transmitting over said application protocol comprises communicating over a secure sockets layer session connection.
  • 6. The method of claim 1, wherein said minimum inactivity time is earlier than the least recent time of connection from a log parsing agent to said unused account detection component in said distributed system deployment.
  • 7. A system for determining whether a user account has been recently used in authentication to an application in a distributed system deployment, said system comprising (a) a client application,(b) an access control component,(c) a directory server,(d) a log parsing agent component,(e) an unused account detection component, and(f) a database attached to said unused account detection component, wherein said client application transmits an identity of a user to said access control component, said access control component transmits a request with a username parameter identifying an account of said user via a directory access protocol to said directory server, said directory server logs said username parameter of said request and an access time as an element in an access log, said log parsing agent component parses said element from said log and transmits over an application protocol said element to said unused account detection component, said unused account detection component updates an access time of a record corresponding to said user account in said database attached to said unused account detection component with said access time from said element transmitted from said log parsing agent, and said unused account detection component compares said access time of said record with a minimum inactivity time.
  • 8. The system of claim 7, wherein said client application, said access control component, said directory server, said log parsing agent component, said unused account detection component and said database are implemented as software running on a general-purpose computer system.
  • 9. The system of claim 7, wherein said access control component transmits said request to said directory server via a lightweight directory access protocol.
  • 10. The system of claim 7, wherein said request is a bind request.
  • 11. The system of claim 7, wherein said request is a search request.
  • 12. The system of claim 7, wherein said log parsing agent component transmits over said application protocol comprising a secure sockets layer session connection.
  • 13. The system of claim 7, wherein said minimum inactivity time is earlier than the least recent time of connection from a log parsing agent to said unused account detection component in said system.
  • 14. A computer program product within a computer usable medium with software for determining whether a user account has been recently used in authentication to an application in a distributed system deployment, said computer program product comprising: (a) instructions for transmitting over a directory access protocol a request from an access control component to a directory server,(b) instructions for logging by said directory server of a username parameter of said request identifying said user account and an access time as an element in an access log,(c) instructions for transmitting over an application protocol said element from a log parsing agent component to an unused account detection component,(d) instructions for updating an access time of a record corresponding to said user account in a database attached to said unused account detection component with said access time from said element transmitted from said log parsing agent, and(e) instructions for comparing said access time of said record with a minimum inactivity time.
  • 15. The computer program product of claim 14, wherein said instructions for transmitting over said directory access protocol comprise instructions for transmitting over a lightweight directory access protocol.
  • 16. The computer program product of claim 14, wherein said instructions for transmitting over said application protocol comprise instructions for transmitting over an application protocol comprising a security sockets layer session connection.
CROSS-REFERENCE TO RELATED APPLICATIONS

This application claims the benefit of PPA Ser. No. 60/838,077 filed Aug. 16, 2006 by the present inventor, which is incorporated by reference.

Provisional Applications (1)
Number Date Country
60838077 Aug 2006 US