1 vote

How does this user log in to the database server, when its login is deactivated on the database server?

Contained database users are always available in Azure SQL Database. Create a user account Create a user account in the database to which a user needs access (also called a contained user). With ...
David Browne - Microsoft's user avatar
1 vote

Logical replication security risk with run_as_owner = false

The risk is the other way around. If you are an unprivileged user and own a table to which data are replicated by the subscription, you could create a trigger on that table and define it as a replica ...
Laurenz Albe's user avatar
  • 51.8k

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