Using IS_MEMBER to determine user role.

[hallst]

Hello all,<br>
I'm using an IS_MEMBER logic in a stored procedure in SQL 7.0 to grant access to portions of the VB front-end.<br>
&quot;IF IS_MEMBER ('rolename') = 1<br>
then....&quot;<br>
<br>
I need to check for user-defined roles. the above code is only cathing fixed roles.<br>
Any suggestions?

 

[PeteAppleton]

I'm doing the same thing.&nbsp;&nbsp;The only difference between the code I'm using & yours is that I'm using<br><br>if is_member([role name]) = 1 begin<br>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;^<br>end&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Note the delimiters<br><br>This works perfectly here.