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

Share:
15,616

Related videos on Youtube

Bee
Author by

Bee

Updated on September 21, 2022

Comments

  • Bee
    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