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 ...
1
vote
Accepted
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
security × 1086sql-server × 577
permissions × 162
mysql × 110
sql-server-2012 × 82
sql-server-2008 × 79
postgresql × 78
sql-server-2008-r2 × 74
logins × 70
oracle × 62
encryption × 58
sql-server-2014 × 51
role × 46
sql-server-2016 × 44
users × 42
database-design × 32
authentication × 31
audit × 28
sql-server-2005 × 23
linked-server × 23
active-directory × 23
stored-procedures × 21
mongodb × 20
azure-sql-database × 20
best-practices × 20