UserGroupMembershipUsers
Query user members of a user group for a SAP Business Objects BI instance.
Select
The following queries are processed server-side:
SELECT * FROM UserGroupMembershipUsers
SELECT * FROM UserGroupMembershipUsers WHERE GroupId=1
SELECT * FROM UserGroupMembershipUsers WHERE GroupId=1 AND Name='test'
Insert
INSERT INTO UserGroupMembershipUsers (GroupId, Id) VALUES (2708, 11)
Delete
DELETE FROM UserGroupMembershipUsers WHERE GroupId=2708
DELETE FROM UserGroupMembershipUsers WHERE GroupId=2708 AND Id=533
Columns
| Name | Type | ReadOnly | Description |
| GroupId [KEY] | Integer | False |
The user group ID. |
| Id [KEY] | Integer | False |
The user ID. |
| CUID | String | True |
The user cluster unique ID. |
| Name | String | True |
The user name. |
| FullName | String | True |
The user full name. |
| String | True |
The user email. | |
| Description | String | True |
The user description. |
| Keywords | String | True |
Keywords of the user group. |
| Created | Datetime | True |
The date time when the user was created. |
| Updated | Datetime | True |
The date time when the user was last updated. |