查询从数据库获取roleid [英] query for getting roleid from db

问题描述

 "  

我想从数据库中获取角色ID

为u.username我在我的项目中有一个文本框，并为此使用where子句..我可以怎么做以获取特定用户表单数据库的roleid ... >我会在想一些简单的事情，例如

Select RoleID from Roles where UserID = @Username

注意-我尚未针对Users表验证用户-我假设在添加角色时就完成了此操作.但是如果我们愿意的话，我会选择这个

Select RoleID from Roles R, Users U 
where R.UserID = U.UserID
and   UserID = @Username

这将为您获取用户和角色:

 选择 rp.name 作为 as database_role，mp.name  as  database_user
来自 sys.database_role_members drm
加入 sys.database_principals rp  on (drm.role_principal_id = rp.principal_id)
加入 sys.database_principals mp 上(drm.member_principal_id = mp.principal_id)

"DELETE FROM Roles WHERE RoleId =@RoleId AND UserId = (SELECT u.UserId FROM Users u WHERE u.UserName = @UserName"

i want to get role id from database

for u.username i have a textbox in my project and use where clause for that.. what i can do to get roleid for particular user form database...

解决方案

I''d be thinking something simple like

Select RoleID from Roles where UserID = @Username

Note - I haven''t validated the user against the Users table - I am asuming that was done when the role was added. But if we wanted to then I would go with this

Select RoleID from Roles R, Users U 
where R.UserID = U.UserID
and   UserID = @Username

This would fetch you the users and roles:

select rp.name as database_role, mp.name as database_user
from sys.database_role_members drm
join sys.database_principals rp on (drm.role_principal_id = rp.principal_id)
join sys.database_principals mp on (drm.member_principal_id = mp.principal_id)

这篇关于查询从数据库获取roleid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！