Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using IS_MEMBER to determine user role.

Status
Not open for further replies.

hallst

IS-IT--Management
Mar 20, 2000
1
US
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top