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!

Search results for query: *

  1. hallst

    Using IS_MEMBER to determine user role.

    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?

Part and Inventory Search

Back
Top