MSSQL 恢復擁有的結構描述

查詢權限狀態

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;

設定權限為預設全縣

ALTER AUTHORIZATION ON SCHEMA::db_datareader TO [db_datareader];
ALTER AUTHORIZATION ON SCHEMA::db_datawriter TO [db_datawriter];
ALTER AUTHORIZATION ON SCHEMA::db_ddladmin TO [db_ddladmin];
ALTER AUTHORIZATION ON SCHEMA::db_denydatareader TO [db_denydatareader];
ALTER AUTHORIZATION ON SCHEMA::db_denydatawriter TO [db_denydatawriter];