check privileges of login youve just used
-
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
-
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 -
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
-
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 -
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