Read-Only User | BestHub

Aikesheng Open Source Community

May 23, 2022 · Databases

Resolving MySQL “Server Has Gone Away” for a Read‑Only User: The Impact of init_connect and SUPER Privilege

The article explains why a newly created read‑only MySQL 5.7 user receives a “MySQL server has gone away” error, analyzes the role of the init_connect variable and SUPER privilege, and provides a step‑by‑step fix by correcting the init_connect setting.

Read-Only UserSUPER privilegeTroubleshooting

0 likes · 10 min read

Resolving MySQL “Server Has Gone Away” for a Read‑Only User: The Impact of init_connect and SUPER Privilege

Laravel Tech Community

Oct 28, 2021 · Databases

Creating a Read‑Only User in SQL Server and Granting Stored Procedure Access

This guide explains how to create a read‑only login in Microsoft SQL Server, map it to specific databases, assign the db_datareader role, and optionally grant permission to view stored procedures, while also summarizing common server and database roles.

Database PermissionsRead-Only UserSQL Server

0 likes · 6 min read

Creating a Read‑Only User in SQL Server and Granting Stored Procedure Access