Post reply

Database Roles: how to query them.

  • May 7, 2004 at 12:46 pm

    #101999

    Database roles are contained in a field (roles) found in the sysusers system table.  The field is binary with an algorythm.  Does any one know the alorythm?  Or is there a procedure/function by passing a uid,sid,id that will return the database roles (if any) that are assigned?

     

    Thanks,

    Jospeh

  • May 7, 2004 at 1:12 pm

    #505708

    Look at sp_helpuser

  • May 7, 2004 at 2:00 pm

    #505714

    That gave me the information I needed.  But I would still be interested if any one knows the Hex algorythm.

     

    Joseph

  • May 7, 2004 at 2:12 pm

    #505715

    Just open the SP in master db in EM. Then you can look at the code it is using to understand it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply