This table is used to identify:
User accounts included in global groups
Global groups included in local groups
User accounts included in local groups
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
auto-numbering of network snapshots. |
|
account_name |
string |
Name of the account owned by the user or by the global group. |
|
owned_group_name |
string |
Name of the global group owned by the local group identified by the account_name. DEPRECATED use owned_account_name and group fields instead. |
|
owned_user_name |
string |
Name of user owned by the group (local or global) identified by account_name.DEPRECATED use owned_account_name and group fields instead. |
|
owned_account_name |
string |
Name of the account (user or group) owned by the group. Linked to the account_name field of the tables users and groups. |
|
group |
string |
1 means the member is a group and will be found in the groups table, 0 means the member is a user and will be found in the users table. |
As an example, in order to list all the users and global groups in the local 'Administrators' group of the 'COPERNET' domain , use the following SQL query:
SELECT owned_group_name, owned_user_name
FROM acc_ownership
WHERE account_name = 'COPERNET\Administrators'