diff options
Diffstat (limited to 'databases/passwords/postgres/passwords.sql')
-rw-r--r-- | databases/passwords/postgres/passwords.sql | 18 |
1 files changed, 0 insertions, 18 deletions
diff --git a/databases/passwords/postgres/passwords.sql b/databases/passwords/postgres/passwords.sql deleted file mode 100644 index cb81cd6..0000000 --- a/databases/passwords/postgres/passwords.sql +++ /dev/null @@ -1,18 +0,0 @@ --- References:
--- : https://www.postgresql.org/docs/current/view-pg-shadow.html
--- : https://www.postgresql.org/docs/current/auth-password.html
--- : https://www.postgresql.org/docs/current/auth-password.html#AUTH-PASSWORD-ENCRYPTION
--- : https://www.postgresql.org/docs/current/runtime-config.html
-
--- Defined password configuration
-SELECT *
-FROM pg_settings
-WHERE name LIKE 'password_%';
-
--- Users and their password configurations
-SELECT
- usename AS user_name,
- passwd AS password,
- valuntil AS valid_until,
- useconfig AS user_config
-FROM pg_shadow;
\ No newline at end of file |