May 7, 2004 at 12:46 pm
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
Look at sp_helpuser
May 7, 2004 at 2:00 pm
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
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