UserDetails
Query details of users for a SAP Business Objects BI instance.
Select
The following queries are processed server-side:
SELECT * FROM UserDetails WHERE Id=11
Update
UPDATE UserDetails SET IsAccountDisabled=true, IsPasswordToChangeAtNextLogon=true, IsPasswordChangeAllowed=true, description='Updated Description', FullName='test updated', IsPasswordExpiryAllowed=false, Title='UpdatedTitle', EmailAddress='[email protected]', Connection=0 WHERE Id=3411
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
The user ID. |
| CUID | String | True |
The user cluster unique ID. |
| FullName | String | False |
The full name of the user. |
| EmailAddress | String | False |
The email address of the user. |
| Description | String | False |
The description of the user. |
| Title | String | False |
The title of the user. |
| ParentID | String | True |
The parent ID. |
| ParentCUID | String | True |
The parent CUID. |
| InboxID | Integer | True |
The user inbox ID. |
| IsAccountDisabled | Bool | False |
If the user account is disabled. |
| IsPasswordToChangeAtNextLogon | Bool | False |
If the password must be changed in the next logon. |
| IsPasswordChangeAllowed | Bool | False |
If user password change is allowed. |
| IsPasswordExpiryAllowed | Bool | False |
If password expiration is allowed. |
| UserGroups | String | True |
The user groups of this user. |
| Connection | Integer | False |
The connection of this user. |
| LastLogonTime | Datetime | True |
The last logon time of the user. |
| Name | String | True |
The name of the user. |
| Type | String | True |
The type of the user. |
| OwnerId | Integer | True |
The id of the user's owner. |
| IsNamedUser | Bool | True |
If the user is a 'named user'. |
| UpdatedAt | Datetime | True |
The datetime when the user was last updated. |