MS-SQL帳號只開放SELECT功能

 MS-SQL帳號只開放SELECT功能

db_datareader

db_denydataeader

--------------------

當無法刪除,必須先把帳號權限移轉

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

--alter authorization on schema::[db_datareader] To [dbo]

--alter authorization on schema::[db_denydatareader] To [dbo]

--alter authorization on schema::[db_denydatawriter] To [dbo]

---------------------