IBM Support

View users that have performed tasks in iBase

How To


Summary

iBase Security Manager allows administrator to select whether an account is active or inactive. However, there is no method of obtaining a list of all active accounts as the dbo._User table in SQL is encrypted for security purposes.

The "iBase Audit Viewer" allows you to view the actions performed in iBase by each specific user, but there is no method of simply obtaining a list of users; this would not be a realistic workaround for environments with hundreds of users and thousands of tasks performed.

In SQL Server, we can obtain a list of actions performed by each user (data coming from the _AuditLog) and then filter this list to only show each user once.

Objective

View users that are active in iBase.

Environment

iBase
SQL Server
This only applies to upsized databases and security files.

Steps

We can see in iBase Designer Security Manager that I have 3 users, however, one of these users is not active and thus cannot perform any tasks in iBase.
security
When we look at the Users appearing in dbo._User table in the _SEC database, we can see the same three usernames appear, but they are encrypted. 
security
We can now run a query to view all the actions in the Audit Log and then filter out the usernames for only distinct occurrences. 
distinct
The results show us 2 distinct accounts that have performed tasks in iBase since 2018 (the year may be changed according to your preferences). The inactive, Raul_test_user_inactive account does not appear in this list as it is unable to perform any tasks. 

Document Location

Worldwide

[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m50000000Ci9aAAC","label":"i2 iBase and i2 Analyst's WorkStation->Database->SQL Server"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
19 January 2021

UID

ibm16405994

Page Feedback