public inbox for [email protected]  
help / color / mirror / Atom feed
[PATCH v2 06/11] distro agnostic
2+ messages / 2 participants
[nested] [flat]

* [PATCH v2 06/11] distro agnostic
@ 2020-09-23 03:55 Justin Pryzby <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Justin Pryzby @ 2020-09-23 03:55 UTC (permalink / raw)

---
 doc/src/sgml/sepgsql.sgml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/sepgsql.sgml b/doc/src/sgml/sepgsql.sgml
index 9961569afc..15417bf19d 100644
--- a/doc/src/sgml/sepgsql.sgml
+++ b/doc/src/sgml/sepgsql.sgml
@@ -88,7 +88,7 @@ Policy from config file:        targeted
   <para>
    To build this module, include the option <literal>--with-selinux</literal> in
    your PostgreSQL <literal>configure</literal> command.  Be sure that the
-   <filename>libselinux-devel</filename> RPM is installed at build time.
+   <filename>libselinux-devel</filename> package is installed at build time.
   </para>
 
   <para>
@@ -177,7 +177,7 @@ $ for DBNAME in template0 template1 postgres; do
    Makefile on your system; the path shown below is only an example.
    (This Makefile is usually supplied by the
    <filename>selinux-policy-devel</filename> or
-   <filename>selinux-policy</filename> RPM.)
+   <filename>selinux-policy</filename> package.)
    Once built, install this policy package using the
    <command>semodule</command> command, which loads supplied policy packages
    into the kernel.  If the package is correctly installed,
-- 
2.17.0


--kH8JNVvasRCCW1Oz
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment;
 filename="v2-0007-style-and-consistency.patch"



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Restoring default privileges on objects
@ 2023-08-29 01:23 Stuart McGraw <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Stuart McGraw @ 2023-08-29 01:23 UTC (permalink / raw)
  To: [email protected]

Hello,

The Postgresql docs on object privileges,
   https://www.postgresql.org/docs/14/ddl-priv.html
say this in regard to the output of the psql \dp command:

   | If the “Access privileges” column is empty for a given object, it
   | means the object has default privileges (that is, its privileges
   | entry in the relevant system catalog is null). [...] The first GRANT
   | or REVOKE on an object will instantiate the default privileges
   | (producing, for example, miriam=arwdDxt/miriam) and then modify them
   | per the specified request.

If I've done a GRANT or REVOKE on some of the tables, how do I restore
the default privileges so that the “Access privileges” appears empty
again?  I re-granted what I think are the default privileges but the
"Access privileges" column for that table contains "user1=arwdDxt/user1"
rather than being blank.  This is Postgresql-14.

Thanks for any suggestions!






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-08-29 01:23 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-09-23 03:55 [PATCH v2 06/11] distro agnostic Justin Pryzby <[email protected]>
2023-08-29 01:23 Restoring default privileges on objects Stuart McGraw <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox