Post reply

Getting user role upon login to application

  • July 17, 2002 at 7:56 am

    #78990

    I need to get a user's SQL Server role when they login to my Access 2000 application. Does anyone know of an API call or some other easy way to grab this information?

    Thanks!

  • July 17, 2002 at 8:23 am

    #432881

    sp_helpuser is one way you can get the roles. They come back in the GroupName section and this can be run by the public role.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • July 17, 2002 at 8:42 am

    #432885

    Thanks alot! I'm new at this so bare with me. My next question is - how do I get the login ID?

  • July 17, 2002 at 11:16 am

    #432910

    You will have to catch input from them to use at application logon or code API methods if they are NT login and id's are the same.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 4 posts - 1 through 4 (of 4 total)

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