public inbox for [email protected]
help / color / mirror / Atom feedALTER DEFAULT PRIVILEGES
2+ messages / 2 participants
[nested] [flat]
* ALTER DEFAULT PRIVILEGES
@ 2022-03-30 11:00 Fredrik Gustavsson <[email protected]>
2022-03-31 08:48 ` Re: ALTER DEFAULT PRIVILEGES Mark Wallace <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Fredrik Gustavsson @ 2022-03-30 11:00 UTC (permalink / raw)
To: [email protected] <[email protected]>
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]
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;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ALTER DEFAULT PRIVILEGES
2022-03-30 11:00 ALTER DEFAULT PRIVILEGES Fredrik Gustavsson <[email protected]>
@ 2022-03-31 08:48 ` Mark Wallace <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Mark Wallace @ 2022-03-31 08:48 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: Fredrik Gustavsson <[email protected]>
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;
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-03-31 08:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-03-30 11:00 ALTER DEFAULT PRIVILEGES Fredrik Gustavsson <[email protected]>
2022-03-31 08:48 ` Mark Wallace <[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