Which field show a user is disabled in Security Repository

security Supervisor (4.x - 6.x)
1

Hi Everyone,

I am querying the security database to count my users per group. As we disabled temporarily some of the users, it would be nice if we could see that too in the database.
Does anyone know if we can see in the security domain database if a user is disabled?
Is this in OBJ_M_ACTOR or OBJ_M_ACTORLINK with a undocumented number?

Thanks

Gaetan Bolon
Schlumberger - BIT

Listserv Archives (BOB member since 2002-06-25)

2

Gaetan,

Check the US BO tech support web site at http://www.busobj.com:

You’ll find there a document (downloadable) with detailed description of the Repository relational structures (tables) as well as a Manager universe (for Oracle) allowing you to audit your repository.

-ACB.

Hi Everyone,

I am querying the security database to count my users per group. As we disabled temporarily some of the users, it would be nice if we could see that too in the database.
Does anyone know if we can see in the security domain database if a user is
disabled?
Is this in OBJ_M_ACTOR or OBJ_M_ACTORLINK with a undocumented number?

Thanks

Gaetan Bolon
Schlumberger - BIT

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

Listserv Archives (BOB member since 2002-06-25)

3

In a message dated 98-11-19 12:20:06 EST, you write:

I am querying the security database to count my users per group.
As we disabled temporarily some of the users, it would be nice if we could see that too in the database.
Does anyone know if we can see in the security domain database if a user is disabled?

I don’t know if this has been answered yet, but the answer is yes. If you look at the M_ACTOR_N_STATUS column in the OBJ_M_ACTOR table you should find values of one (1) or zero (0). A value of zero apparently designates a disabled user.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)