Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    32

    Unanswered: command to show users of a role

    Hi
    I am just wondering if there is any sybase command to show the name of the users that a role has?

    I have a role "SUPPORT" and I want to know what users have been assigned to that role

    Thanks in advance for your help

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    There is no specific command, but you can use this query:
    Code:
    select sr.name, sl.name
    from syssrvroles sr, syslogins sl, sysloginroles slr
    where sl.suid = slr.suid
    and sr.srid = slr.srid
    and sr.name like "sa_role"
    In the last line, you can substitute sa_role with any role-name you want to know the members of.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •