Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkXEs-0000CI-Qy for pgsql-admin@arkaria.postgresql.org; Wed, 02 Dec 2020 18:52:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkXEr-0000fO-Fy for pgsql-admin@arkaria.postgresql.org; Wed, 02 Dec 2020 18:52:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkXEr-0000fH-5s for pgsql-admin@lists.postgresql.org; Wed, 02 Dec 2020 18:52:29 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kkXEk-0005Ij-LR for pgsql-admin@postgresql.org; Wed, 02 Dec 2020 18:52:28 +0000 Received: by mail-qv1-xf32.google.com with SMTP id p12so1191820qvj.13 for ; Wed, 02 Dec 2020 10:52:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:date:subject:message-id :to; bh=JngQR9yd4BHjKkITEmUBaov6Vt/fBrFsSd75tm7bYEg=; b=FI9g1yfx6CrwCIOm7RRBBFnpz7WCrZvNyhzM8BzOtEoh2K1ntF70oVipnmvQ2RQLKv DGVyPqG9tpVLNFZq/SjGk38htXlKAOikpQAVdc5GAj7pxu/hubwbCunRQUDJ6Avbht5J 96wALvjtH7YeB08VgGJkeNeDEKiDaTfhbAp9ovNmCjKM8QkQRsb/sbCQTD8IvrZ3DW2R z1e600E7bg2XcrdgokQWc3id/ElOB7/7T7MhqTuSIoiWi70bIzlk/SsBwnai5dg/V2+i 2FeF3Rgnf4BMwwJIIGtC1ouo8HXoaNMwXNHQ8zqk+bS1d223bMc3hRnpCWq6uRzbUa2e XRYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version:date :subject:message-id:to; bh=JngQR9yd4BHjKkITEmUBaov6Vt/fBrFsSd75tm7bYEg=; b=WxZoQNWRTH56n2t+Xo1fbn3Zf3nGBg7kEEm/DjrjZaukC3rBiKh5iijLpVG8mPKO4x 9mBqOYuRmfkbjbrvp4VSafa3omOAkSUqY78KW0o1uzvvK3So4Ifshxi8/Zd97UrGkfyV nGzvSFPnMZNl1zxZB7kr3Qbtv5j2LKmB7tQfAoRsuoDNJOCWCFODogoRbAVYRgfSnqLr /EGWSPicON9vdmhQQTwyfYRqJYihaiQxchSA0CU+0sGRPfVon778qDTr7Sxc+heagqqx 78ZEzYrUPm6Zao2Q7KBAwy4ezw5rm2eEog9Xp0LxEecqO+bM42AFcs8CNG2+s8TrfgV6 sukw== X-Gm-Message-State: AOAM532RD2+KpBYYFedX+Aynhp8VGwTFCDJ543XtVVNJNbeIsVJhoC9b zCkiAmC8iitWbqia4OO4KXyQp3A/SX0= X-Google-Smtp-Source: ABdhPJyph/CKf4L5DjInVBnad2lqXMMYWG/iUcKpcUCzkQdWxLrw5ol6TnGihcbeskdvR8/7ev3Jqg== X-Received: by 2002:a0c:b5c7:: with SMTP id o7mr4022340qvf.16.1606935140695; Wed, 02 Dec 2020 10:52:20 -0800 (PST) Received: from [192.168.254.67] (h178.165.133.40.static.ip.windstream.net. [40.133.165.178]) by smtp.gmail.com with ESMTPSA id h142sm2722122qke.104.2020.12.02.10.52.19 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 02 Dec 2020 10:52:19 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Date: Wed, 2 Dec 2020 13:52:18 -0500 Subject: Seeing privileges on a schema Message-Id: <19031B53-2D47-407B-9F85-60E303F2ABCA@gmail.com> To: pgsql-admin X-Mailer: iPad Mail (18B92) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk In psql, I know that \dp or \dpp will show me which privileges are granted o= n tables, views, sequences, and functions, what it doesn=E2=80=99t appear to= be able to do, is show me what privileges are in the schema itself, like if= I grant usage on a schema. Then a \dpp doesn=E2=80=99t produce anything. Is= there an easy way to see what privileges are on a schema? =E2=80=94 Jay Sent from my iPad=