Re: How to remove user specific grant and revoke

Andrus <kobruleht2@xxxxxx> · Sat, 3 Jun 2023 23:33:22 +0300



    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_owner) or a
      superuser in case you
      
        not already tried that.  
      
      REVOKE was executed by superuser, postgres. PgAdmin uses this user
      to log on.

      
        Do you get any errors?
      
      There are no errors.
      Andrus.