Find pkg added users/groups

[Nikolai Lifanov]

On 12/2/16 9:47 AM, Nikolai Lifanov wrote:
>
>
> On 12/2/16 7:00 AM, freebsd-pkg-request at freebsd.org wrote:
>
>>
>> pkg info -l lets me see what files a package adds. Is there any easy way
>> to see what users and groups (if any) a package adds?
>>
>
> pkg shell to the rescue:
>
> $ echo "
> SELECT DISTINCT users.name
> FROM packages,pkg_users,users
> WHERE packages.id=package_id
> AND users.id=user_id
> AND packages.name='virtualbox-ose';
> " \
>  | pkg shell
> vboxusers
>
> You can do the same thing for groups.
>
> - Nikolai Lifanov

You can also just get all packages, users, and groups in a similar way:

$ echo "
SELECT DISTINCT packages.name,groups.name,users.name
FROM packages,pkg_users,users,pkg_groups,groups 
       WHERE packages.id=pkg_users.package_id
AND packages.id=pkg_groups.package_id
AND groups.id=group_id
AND users.id=user_id;
" \
  | pkg shell
tpm-emulator|_tss|_tss
avahi-app|avahi|avahi
colord|colord|colord
policykit|polkit|polkit
transmission-daemon|transmission|transmission
webcamd|webcamd|webcamd
hal|haldaemon|haldaemon
cups|cups|cups
polkit|polkitd|polkitd
trousers|_tss|_tss
virtualbox-ose|vboxusers|vboxusers
nginx|www|www
dbus|messagebus|messagebus
git|git_daemon|git_daemon

- Nikolai Lifanov