I would like to know if there is a query to export the user rights select insert grant
and so on, to a SQL file.
I managed to get the list of the Grants:
Select * from INFORMATION_SCHEMA.TABLE_PRIVILEGES
I would like to know if there is a query to export the user rights select insert grant
and so on, to a SQL file.
I managed to get the list of the Grants:
Select * from INFORMATION_SCHEMA.TABLE_PRIVILEGES
How to Script User and Role Object Permissions in SQL Server
Might also be of interest: How to transfer logins and passwords between instances of SQL Server