Post reply

How to use Roles in Code

  • May 22, 2006 at 11:30 pm

    #168212

    I am developing a travel agency database system using sql 2000, and the agency have more than hundred users. I created Roles in order to allow for security control of users. Is there a way to reference those groups in T-SQL, and what is the syntax for that. I already know how to reference users (suser_sname()) but i am missing on reference to Database Roles.

    I am using SQL Authentication and not Windows NT

  • May 23, 2006 at 12:09 am

    #639421

    The two documented role specific stored procedures are:

    sp_helprole

    sp_helprolemember

  • May 24, 2006 at 6:55 am

    #639746

    The IS_MEMBER() function may be of use to you as well.

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

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