All Forums Database
wambli 5 posts Joined 02/12
09 Feb 2012
Revoke User

I have a script that revokes logon on firecall users after X days.  It will then drop the user 14 days after that.  I am looking for the table that contains the flag/field that shows the user was revoked.  I want to use this as a check to do a compare. 

dins2k2 51 posts Joined 05/13
03 Jun 2013

Even I have the same question. Where to check whether a user is revoked or not? Any views or tables are there? Please help.

dins2k2 51 posts Joined 05/13
03 Jun 2013

Hi wambli, DBC.LogonRules view has a column named LogonStatus which contains the flag whether user is granted (G) or revoked (R) logon access.
This view uses information from real table DBC.LogonRuleTbl.

Swapna1083 1 post Joined 06/16
28 Jun 2016

Hi,We have checked in DBC.LogonRules but we are unable to retrieve the information for all users,can you or anyone can help me how to get the information

Fred 1096 posts Joined 08/04
30 Jun 2016

You typically don't have LogonRules for every user; there are generic / "wild card" rules as well. The search order is:

  • Session UserName and LogicalHostID both match a rule
  • Session UserName matches a rule with LogicalHostID = 1024 (ON ALL)
  • Session LogicalHostID matches a rule with Username = Default (AS DEFAULT)
  • Else a rule with LogicalHostID=1024 and Username = Default (if any)


You must sign in to leave a comment.