Problem: Login with admin rights

I had the similar select statement but it keeps on returning positive even if the user logged in doesn't have admin rights...Unless there's another method.


Select r.RoleId, u.UserId, sys.RoleId, sys.UserId  From Role r, User u, UserRoleLink sys

Where r.RoleId = sys.roleId AND u.UserId = sys.UserId  AND r.RoleDesc = 'Managing Director'

try

select
    A.Username
    , C.RoleDescription
from
    tblUser A
    , tblUserRolelink B
    , tblRole C
where
    B.UserId = A.UserId
    and C.RoleId = B.RoleId
    and A.Username = xxxx
;