Hi,
I want to create a report to list disable users (i.e. not having Log-in enabled privelege).
Please help me in that.
regards,
Baber.
This should do what you desire...
select ID, NAME, LASTNAME, FIRSTNAME, DELETED, USERPRIVILEGES from KUAF where Type=0 and Deleted=0 and userprivileges = 2062
Thanks very much.
There is a small problem in it as if a user is disabled and having privelege enabled other than public has some other privelege code. How to handle that?
Hi Baber
You need to check a specific bit.
How you do it is DB specific, so my question is…
Are you using SQL server or Oracle for your DB?
Regards
Lindsay
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: 2012 July 10, Tue 09:01To: eLink RecipientSubject: List of disabled users in livelink
List of disabled users in livelink
Posted bybaber.amin@dolphinenergy.com (Amin, Baber) On 07-10-2012 03:58
[To post a comment, use the normal reply function]
Topic:
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
we have oracle.
OK these queries are for Oracle.
SQL server would use a slightly different technique.
Bit 1 is used for Login Enabled / Disabled.
These two queries will check to disabled users and enabled users respectively.
The first query would show names with “(delete)” appended for deleted users because they are disabled as well as users with other privileges who are disabled.
select id,name,userprivileges
from kuaf
where type = 0
and bitand(userprivileges,1) = 0
and bitand(userprivileges,1) = 1
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: 2012 July 10, Tue 11:02To: eLink RecipientSubject: RE List of disabled users in livelink
RE List of disabled users in livelink
Posted bybaber.amin@dolphinenergy.com (Amin, Baber) On 07-10-2012 05:59
