Hi all,
Hopefully someone can point me in the right direction, i simply want a report to show if the users are enabled or disabled. However I cannot see anything in the database tables to suggest if a user is enabled/disabled.
Thanks,
Fraz
Please see the post here:
https://knowledge.opentext.com/knowledge/cs.dll/open/4362317
- Bhupinder
Many thanks Bhupinder
The Disabled or Enabled is found in the KUAF.USERPRIVILEGES. Bits are on or off.
To have nothing turned on, but be active, but disabled: 14
To be Active, but disabled and have Public Access enabled: 2062.
There are other combinations should any of the other lower selections be chosen, but the ID is disabled.
For ORACLE:
Select k.id, k.name
From kuaf k
Where k.userprivileges in (14, 2062)
Order by k.lastname, k.firstname
Colin J. Schmidt
MSLive/Livelink Admin
Tulsa, OK 74172
Colin.Schmidt@williams.com
If you have received this message in error, please reply to advise the sender of the error and then immediately delete this message.
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, April 23, 2013 8:45 AMTo: eLink RecipientSubject: User enabled or disabled? Report 2
User enabled or disabled? Report 2
Posted by falyas@buckscc.gov.uk (Alyas, Firaz) On 04-23-2013 09:32
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
Thanks Colin
