“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)
“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 (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 (BOB member since 2002-06-20)