Azure SQL中的所有用户列表 [英] List of all users in Azure SQL

问题描述

如何列出所有可以连接到我的SQL Server数据库的用户?现在可以找到任何sql命令.我尝试了互联网上可用的链接很少，但没有一个起作用.

How can I list all users which can connect to my sql server database? Now able to find any sql command. I tried few links available on the internet but none of them worked.

我尝试过的一些命令

SELECT * FROM sys.sql_logins;

SELECT * FROM sys.sysusers;

select * from sys.sysusers
SELECT [name], [sid]
FROM [sys].[database_principals]
WHERE [type_desc] = 'SQL_USER'

我还查看了azure门户，但未找到任何用户信息.

I also looked in azure portal but did not find any users information.

我能够连接到提供我的用户名和密码的连接字符串的sql数据库.现在，我无法在sql server中找到该用户ID.

I am able to connect to sql database which connection string where I am providing userid and password. Now I am not able to find that userid in sql server.

连接字符串看起来像

value="Server=server,1433;Initial Catalog=DB1;Persist Security Info=False;User ID=user1;Password=pass1;Encrypt=True;Connection Timeout=30;" 

推荐答案

在主服务器上运行此查询:

Run this query on master:

SELECT A.name as userName, B.name as login, B.Type_desc, default_database_name, B.* 
FROM sys.sysusers A 
    FULL OUTER JOIN sys.sql_logins B 
       ON A.sid = B.sid 
WHERE islogin = 1 and A.sid is not null

在用户数据库上运行此

SELECT DB_NAME(DB_ID()) as DatabaseName, * FROM sys.sysusers

这篇关于Azure SQL中的所有用户列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！