MYSQL's "FLUSH PRIVILEGES" equivalent in SQL Server?
15,616
Solution 1
In SQL Server permissions are applied immediately, no need to flush anything. The moment a GRANT, REVOKE or DENY is issued it is in effect
Solution 2
You should use FLUSH PRIVILEGES; only if you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE.
See: Stop using FLUSH PRIVILEGES
Related videos on Youtube
Author by
Bee
Updated on September 21, 2022Comments
-
Bee over 1 year
Is there a MYSQL's
"FLUSH PRIVILEGES"
equivalent existing in SQL Server?Or, are the changed permissions implicitly updated in SQL Server?
Hope my question is clear.
Thanks,
Bhathiya