About OBJ_M_ACTOR Table.

“I can values like 256, 264, 288, 320, 384 in M_ACTOR_N_STATUS column of OBJ_M_ACTOR. How can I deduce the status of a user from these values.”


subodhgupta (BOB member since 2004-06-22)

Did you try a search on BOB, suggested keyword: M_ACTOR_N_STATUS

Does this post help for starters?


Andreas :de: (BOB member since 2002-06-20)

HI Andreas,

Did find the thread which you attached. The status should be 1 for an enabled user but I have all my users (well, most of them) with status 256, which is no where in the documentation.

I guess, I need to calculate it using bitand operator or something like that using code as under:
decode(bitand(a.m_actor_n_status,1),‘X’) as “Enabled”,
decode(bitand(a.m_actor_n_status,2),2,‘X’) as “Locked”,
decode(bitand(a.m_actor_n_status,4),0,‘X’) as “Enable Offline”,
decode(bitand(a.m_actor_n_status,8),0,‘X’) as “Enable Passwd Mod”,
decode(bitand(a.m_actor_n_status,32),0,‘X’) as “Enable RTR”,
decode(bitand(a.m_actor_n_status,64),0,‘X’) as “Enable Del Docs”,
decode(bitand(a.m_actor_n_status,128),0,‘X’) as “3 Strike Fail”

but somehow, my values are not correct and hence I am confused.

Subodh.


subodhgupta (BOB member since 2004-06-22)

For example:

Status 264 =


decode(bitand(a.m_actor_n_status,8),'X') as "Enable Passwd Mod", 
decode(bitand(a.m_actor_n_status,256),256,'X') as "Disable 415" 
 

Sum of the above listed status codes: 8 + 256 = 264


Andreas :de: (BOB member since 2002-06-20)