Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MYSQL's "FLUSH PRIVILEGES" equivalent in SQL Server?

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

like image 243
Bee Avatar asked Mar 12 '26 06:03

Bee


1 Answers

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

like image 127
SQLMenace Avatar answered Mar 13 '26 21:03

SQLMenace



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!