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

    Unanswered: command to show users of a role

    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
    Provided Answers: 4
    There is no specific command, but you can use this query:
    from syssrvroles sr, syslogins sl, sysloginroles slr
    where sl.suid = slr.suid
    and sr.srid = slr.srid
    and 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