From owner-freebsd-pkg@freebsd.org Fri Dec 2 15:01:30 2016 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 74AAAC62E6E for ; Fri, 2 Dec 2016 15:01:30 +0000 (UTC) (envelope-from lifanov@mail.lifanov.com) Received: from mail.lifanov.com (mail.lifanov.com [206.125.175.12]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 62FCC1B41 for ; Fri, 2 Dec 2016 15:01:30 +0000 (UTC) (envelope-from lifanov@mail.lifanov.com) Received: from [10.14.0.54] (unknown [198.85.229.3]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by mail.lifanov.com (Postfix) with ESMTPSA id B064D239488 for ; Fri, 2 Dec 2016 10:01:29 -0500 (EST) Subject: Re: Find pkg added users/groups To: freebsd-pkg@freebsd.org References: From: Nikolai Lifanov Message-ID: Date: Fri, 2 Dec 2016 10:01:28 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Dec 2016 15:01:30 -0000 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