Running System Access Reports on Applications 2448

  • Just wondering if anyone here would be able to tell me how you could run System Access reports to find out what employees currently have rights to access certain applications. Main reason being that an auditor will have HR run a list of who currently is employed by my organization, then match that against System access privilages and see if there are exemployees that still have access to the system.
    Again thanks for any help with this matter.
    PS tried a search this time and nothing. (Huge tool though, thanks for pointing that out Harry.)
    :lol: :lol:

  • Don’t you love answers that start out with depends? In any event it really does depend. Generally, systems that are accessible via networks handle system access using two different methods. One is group permissions the other is generally accounts that are set up in a database (I.E. user identifier, username, and password are stored in a database). The former is the easiest to determine. A query can simply be run against the table/s in the database that contain the information that controls access. Usually users are identified by some type of employee number that could be cross referenced with HR data in some type of ad-hoc excel spreadsheet. In the first scenario, (group permissions). Groups are created usually by a network systems administrator. The groups may be like accounting, HR, sales, etc. . . The admin allows access to the application by specifying which group can access the application, (I.E. only accounting can access Oracle Financials). This could easily be determined by getting a list of applications, the groups that have access to the application, and who belongs to those groups. This could be made available by a network systems administrator.

  • Awesome, thanks for clearnig that up. I was almost certain it could be determined by a simple select query, unfortunatley i think we currenly run groupings. The information you have provided will save me plenty of time, thanks again for all the help.

Log in to reply