Post reply

check privileges of login youve just used

  • July 1, 2004 at 4:20 am

    #108256

    Hey all,

    I'm testing a bunch of new logins, both SQL Sever and Windows authentication, that have been handed off to me.  Want to be able to login with QA and then see the permissions that login has on the server.

    I can't remember/find how to check privileges for a login I'm using at the moment.  sp_helpuser isn't it.

    much appreciated

    Skål - jh

  • July 1, 2004 at 5:15 am

    #512847

    Check out xp_logininfo.  also BOL if you look this up has some other info xp_loginconfig, etc...

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 1, 2004 at 6:19 am

    #512864

    Very helpful thank you, and excellent info from one so young!  Now we know we really have to watch our backs Ms. Ahrens.  As always, my searching skills w/ BOL and Google need improving.

    The next thing tho is finding this info when the login is not an admin and so does not have rights to execute xp_logininfo.

    You helped me get the most import logins tested as requested, this next step is less urgent but now I'm really curious.

    Skål - jh

     

    Skål - jh

  • July 1, 2004 at 4:36 pm

    #513041

    John,

    I can't resist showing people my daughter

    With that said... THANK GOD she looks like mommy and NOT me

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 1, 2004 at 4:40 pm

    #513043

    Ah, got me.  Great Pic!

    I'm still watching my back tho.

    Skål - jh

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

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