Felipe Gasper wrote > Hello, > > Is there a way to temporarily suspend a user account? > > I would prefer not to revoke login privileges since that will break > things that mine pg_users and pg_shadow. > > I also am trying to find something that is completely reversible, so > something like setting connection limit to 0, which would lose a > potentially customized connection limit, doesn’t work. > > We do this in MySQL by reversing the password hash then running FLUSH > PRIVILEGES; however, that doesn’t seem to work in PostgreSQL/pg_authid > as some sort of cache prevents this from taking effect. > > Has anyone else solved this issue? Thank you! Personally untested: ALTER ROLE role_name VALID UNTIL 'timestamp' --i.e., set that to sometime in the past http://www.postgresql.org/docs/9.4/interactive/sql-alterrole.html David J. -- View this message in context: http://postgresql.nabble.com/Temporarily-suspend-a-user-account-tp5836978p5836982.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
