Date: Fri, 2 Dec 2016 10:01:28 -0500 From: Nikolai Lifanov <lifanov@mail.lifanov.com> To: freebsd-pkg@freebsd.org Subject: Re: Find pkg added users/groups Message-ID: <d2861c74-1c66-620e-81d6-f66ac050125d@mail.lifanov.com> In-Reply-To: <fe6a6ba7-e4b7-ba7c-9823-a02bf2a2bb52@mail.lifanov.com> References: <mailman.15.1480680000.28059.freebsd-pkg@freebsd.org> <fe6a6ba7-e4b7-ba7c-9823-a02bf2a2bb52@mail.lifanov.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 12/2/16 9:47 AM, Nikolai Lifanov wrote:
>
>
> On 12/2/16 7:00 AM, freebsd-pkg-request@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?d2861c74-1c66-620e-81d6-f66ac050125d>