I have SQL Server 2012 Enterprise. I have an SQL user that is not sysadmin on the server. The user is allowed to read and write the DB; but it cannot change Read-Only flag (Database Properties -> Options -> Database  Read-Only) of the  DB. What should be done to allow the user to change Read-Only flag?

​I have SQL Server 2012 Enterprise. I have an SQL user that is not sysadmin on the server. The user is allowed to read and write the DB; but it cannot change Read-Only flag (Database Properties -> Options -> Database  Read-Only) of the  DB. What should be done to allow the user to change Read-Only flag?  Read More

​