獲取登錄名數(shù)據(jù)庫實例級權(quán)限

發(fā)布時間：2020-08-01 10:32:03 來源：網(wǎng)絡(luò) 閱讀：483 作者：Kassadar 欄目：關(guān)系型數(shù)據(jù)庫

SELECT 'EXEC master..sp_addsrvrolemember @loginame = N'''+loginname+''', @rolename = N'''+priv+''''
FROM
(
    SELECT loginname, priv, value
    FROM
    (
        SELECT loginname, sysadmin, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator, bulkadmin
        FROM sys.syslogins
    ) AS a UNPIVOT(value FOR priv IN(sysadmin, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator, bulkadmin)) AS UPV
) AS T
WHERE VALUE = 1;
![](https://cache.yisu.com/upload/information/20200311/41/171158.jpg?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)

向AI問一下細(xì)節(jié)

獲取登錄名數(shù)據(jù)庫實例級權(quán)限

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽