共計 1210 個字符，預(yù)計需要花費 4 分鐘才能閱讀完成。

這篇文章主要為大家展示了“MSSQL 怎么看各個 ID 對應(yīng)具體 DB 的角色”，內(nèi)容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓丸趣 TV 小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“MSSQL 怎么看各個 ID 對應(yīng)具體 DB 的角色”這篇文章吧。

 exec sp_MSforeachdb insert into dbcenter..user_role_map ([DB_NAME],[uid],[uStatus],[uName],[rId],[rStatus],[rName])select ? ,a.uid as uid,a.status as uStatus,a.name as uName,
  b.uid as rId,b.status as rStatus,b.name as rName
from sysusers a left join sysmembers m on m.memberuid = a.uid 
    left join sysusers b on b.gid = m.groupuid
where a.issqluser =1

–select substring(name, 1, 70) Login Name ,dbname from master..syslogins

– 用戶與角色關(guān)系

USE [DBCenter]
GO
–drop table [DBCenter].[dbo].[user_role_map]
CREATE TABLE [dbo].[user_role_map](
[DB_NAME] [varchar](20) NOT NULL,
[uid] [int] NULL,
[uStatus] [int] NULL,
[uName] [sysname] NOT NULL,
[rId] [int] NULL,
[rStatus] [int] NULL,
[rName] [sysname] NULL
) ON [PRIMARY]

use master 
go

exec sp_MSforeachdb
insert into dbcenter..user_role_map([DB_NAME],[uid],[uStatus],[uName],[rId],[rStatus],[rName]) 
select ? as db_name,a.uid as uid,a.status as uStatus,a.name as uName,
  b.uid as rId,b.status as rStatus,b.name as rName
from sysusers a left join sysmembers m on m.memberuid = a.uid 
    left join sysusers b on b.gid = m.groupuid
where a.issqluser =1
go

select * from dbcenter..user_role_map

以上是“MSSQL 怎么看各個 ID 對應(yīng)具體 DB 的角色”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學(xué)習(xí)更多知識，歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道！