| title | DBCC FLUSHAUTHCACHE (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | DBCC FLUSHAUTHCACHE empties the database authentication cache containing information about logins and firewall rules, for the current user database in Azure SQL Database. | ||||
| author | VanMSFT | ||||
| ms.author | vanto | ||||
| ms.reviewer | randolphwest | ||||
| ms.date | 11/13/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | t-sql | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | = azuresqldb-current || = fabric-sqldb |
[!INCLUDE Azure SQL Database FabricSQLDB]
Empties the database authentication cache containing information about logins and firewall rules, for the current user database. Additionally, it clears all cached Microsoft Entra group membership data stored in the database.
DBCC FLUSHAUTHCACHE doesn't apply to the logical master database, because the master database contains the physical storage for the information about logins and firewall rules.
The user executing the statement and other currently connected users remain connected.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DBCC FLUSHAUTHCACHE
[;]
None.
The authentication cache makes a copy of logins and server firewall rules stored in the master database, and places them in memory in the user database.
A user with the KILL DATABASE CONNECTION permission can explicitly terminate a connection to [!INCLUDEssSDS] by using the KILL (Transact-SQL) command.
DBCC FLUSHAUTHCACHE is not supported for [!INCLUDEssazuresynapse-md].
Requires the KILL DATABASE CONNECTION permission [!INCLUDEssSDS] or the admin account.
The following statement clears the authentication cache for the current database.
DBCC FLUSHAUTHCACHE;