public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mark Wallace <[email protected]>
To: [email protected] <[email protected]>
Cc: Fredrik Gustavsson <[email protected]>
Subject: Re: ALTER DEFAULT PRIVILEGES
Date: Thu, 31 Mar 2022 04:48:42 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <AM0PR04MB49325ADD078814DC3F496A7BDF1F9@AM0PR04MB4932.eurprd04.prod.outlook.com>
References: <AM0PR04MB49325ADD078814DC3F496A7BDF1F9@AM0PR04MB4932.eurprd04.prod.outlook.com>
One revokes privileges only with the REVOKE command.
See: PostgreSQL 9.5 documentation, pages 1642-1645.
> On Mar 30, 2022, at 07:00, Fredrik Gustavsson <[email protected] <mailto:[email protected]>> wrote:
>
> HelloTeam
>
> I have a question on how to revoke privileges granted by another user
> \ddp shows (Swedish names)
> Owner | Schema | Type | Access privileges
> --------------------+------------------------+----------+-------------------------------------------
> sbkrojo | kom_enhetskatalogen_v1 | table | leveransdata_r=r/sbkrojo +
> | | | leveransdata_w=arwdDxt/sbkrojo +
> | | | ponf_r=r/sbkrojo +
> | | | tk_r=r/sbkrojo
>
> The two last lines is the ones I whish to get rid of
> I tried the following sql statement
> ALTER DEFAULT PRIVILEGES IN SCHEMA kom_enhetskatalogen_v1 revoke all on tables from tk_r
> but the grant is still present
> Also tried to grant myown id to role sbkrojo,;
> GRANT SBKROJO O MYID WITH ADMIN OPTION;
> But I’m still not able to remove the privileges from tk_r.
> Is there a way to achieve this ?
> Sbkrojo is an old user no longer with our organization but I don’t want to change the pwd for it since there are bach jobs running under the same id.
> We are running
> postgres (PostgreSQL) 9.5.2 on windows server 2012.
> Thanks for your support
>
> Best regards
>
> Vänliga hälsningar
>
> Fredrik Gustavsson
>
> Systemadministratör
> Geodataavdelningen
>
> GÖTEBORGS STAD
> Stadsbyggnadskontoret
>
> Telefon: 031-36880801
> E-post: [email protected] <mailto:[email protected]>
>
> Postadress: Box 2554, 403 17 Göteborg
> Besök: Köpmansgatan 20
> www.goteborg.se <http://www.goteborg.se/;
>
> Så här behandlar stadsbyggnadskontoret dina personuppgifter <https://goteborg.se/wps/portal?uri=gbglnk%3a20185816278319;
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: ALTER DEFAULT PRIVILEGES
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox