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>