Skip to main content
2 votes

How to correctly replace 'default_authentication_plugin' with 'authentication_policy'?

For the newest mysql 8.4 see the following: The --default-authentication-plugin=mysql_native_password is removed, because native-password ...
Gooze's user avatar
  • 21
1 vote

Query postgres db in a Docker container from another container using peer auth

I was able to accomplish this via postgres_fdw. This article describes the process. Here are my steps: -- Add postgres_fdw extension CREATE EXTENSION IF NOT EXISTS postgres_fdw; -- Set up connection ...
Borislav Zlatanov's user avatar
1 vote

Module signing on a trigger which accesses system views. Base table is on a custom schema

First of all, when I reproduce using your code - I have a different message: Msg 300, Level 14, State 1, Procedure AuditINSERT, Line 9 [Batch Start Line 0] VIEW SERVER PERFORMANCE STATE permission ...
Zikato's user avatar
  • 4,812
1 vote

SQL Server login with specific permissions

You should never use process admin that can kill any query running of any user... You should use a SQL user in all non-system db associates with the login and give it the db_datawriter, db_datareader ...
SQLpro's user avatar
  • 509
1 vote

PostgreSQL: Pgbouncer authentication

The point of pgbouncer is that not every connection to pgbouncer creates a new connection to the database. Or at least, that is a major point, maybe it is not the only point. An incoming connection ...
jjanes's user avatar
  • 40.1k
1 vote

PostgreSQL: Pgbouncer authentication

It is confusing. Since pgBouncer acts as a proxy between client and database, authentication happens at two stages: the client has to authenticate with pgBouncer pgBouncer has to authenticate with ...
Laurenz Albe's user avatar
  • 53.4k
1 vote

How do I change the Authentication Plugin for users mysql.sys, mysql.session, etc?

Most likely you've found this error message in your logs: [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. ...
ElvinAtombender's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible