aboutsummaryrefslogtreecommitdiff
path: root/databases/passwords/postgres/passwords.sql
diff options
context:
space:
mode:
Diffstat (limited to 'databases/passwords/postgres/passwords.sql')
-rw-r--r--databases/passwords/postgres/passwords.sql18
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