Hi!
>From your first message I was under the impression that pgAdmin shows one
REVOKE ALL for every GRANT, i.e. all REVOKE commands at once. If that is not
the case you may have found a bug in pgAdmin. Please ask on the pgadmin-support
list or open a GitHub issue.
Speaking of which, I foundh
> On 04/06/2023 00:08 CEST Andrus wrote:
>
> > Should I ran separate revoke commands for every user to remove those
> > revokes ?
> > How to remove user-spefic grants ?
> After running revoke commands in psql, GRANT commands disappeared magically.
> It looks like pgAdmin does not allow execute REV
> On 03/06/2023 23:34 CEST Andrus wrote:
>
> psql (12.2 (Debian 12.2-2.pgdg100+1))
> Type "help" for help.
>
> sba=# REVOKE ALL ON public.kaspriv FROM alekspoluh;
> REVOKE
> sba=# \o result.txt
> sba=# \dp public.kaspriv
>
> sba=# \q
> #grep alekspoluh result.txt
> Returns nothing. So output
Hi!
Should I ran separate revoke commands for every user to remove those
revokes ?
How to remove user-spefic grants ?
After running revoke commands in psql, GRANT commands disappeared
magically. It looks like pgAdmin does not allow execute REVOKO commands.
After running script which add
Hi!
After this command pgAdmin still shows revoke and grant commands for
alekspoluh role.
How to remove all grant and revoke assignments for role ?
Please confirm that \dp public.kaspriv no longer shows an ACL for alekspoluh
after running:
REVOKE ALL ON public.kaspriv FROM alekspoluh;
> On 03/06/2023 22:33 CEST Andrus wrote:
>
> I tried
> alter role alekspoluh reset all
This only resets role-specific settings, not privileges.
> After this command pgAdmin still shows revoke and grant commands for
> alekspoluh role.
> How to remove all grant and revoke assignments for role ?
P
Hi!
I tried
alter role alekspoluh reset all
After this command pgAdmin still shows revoke and grant commands for
alekspoluh role.
How to remove all grant and revoke assignments for role ?
Andrus.
03.06.2023 20:50 Andrus kirjutas:
Hi!
> REVOKE must be executed by the grantor (sba_owne
> On 03/06/2023 18:14 CEST Andrus wrote:
>
> > Or just execute those REVOKE ALL commands (except for PUBLIC) that pgAdmin
> > already gives you.
> pgAdmin gives
> REVOKE ALL ON TABLE public.kaspriv FROM someuser;
> I ran it but pgAdmin still gives this statement.
What are the current table privil
Hi!
Or just execute those REVOKE ALL commands (except for PUBLIC) that pgAdmin
already gives you.
pgAdmin gives
REVOKE ALL ON TABLE public.kaspriv FROM someuser;
I ran it but pgAdmin still gives this statement.
Andrus.
> On 03/06/2023 14:46 CEST Erik Wienhold wrote:
>
> > On 03/06/2023 09:16 CEST Andrus wrote:
> >
> > DROP REVOKE ALL ON TABLE public.kaspriv FROM all EXCEPT public;
> > DROP GRANT SELECT ON TABLE public.kaspriv FROM all EXCEPT public;
> >
> > This will be one-time action. It can be done manually
> On 03/06/2023 09:16 CEST Andrus wrote:
>
> User groups table is defined as
>
> CREATE TABLE IF NOT EXISTS public.kaspriv
> (
> id serial primary key,
> user character(10) NOT NULL,
> group character(35) NOT NULL
> ...
> )
>
> There are hundreds of users. Earlier time grant and revoke commands we
User groups table is defined as
CREATE TABLE IF NOT EXISTS public.kaspriv
(
id serial primary key,
user character(10) NOT NULL,
group character(35) NOT NULL
...
)
There are hundreds of users. Earlier time grant and revoke commands were
executed for every
12 matches
Mail list logo
