RE: What are the permissions required at OS level to run xp_logini
From: Craig (CraigNicholas_at_online.nospam)
Date: 11/28/05
- Next message: Andy Davis: "Re: Setting SQL Permissions - please respond to this simple questi"
- Previous message: Uri Dimant: "Re: User can't access his own objects"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 28 Nov 2005 02:53:06 -0800
Hi,
I've just got notice of your replies; thanks.
This does not seem to be a problem with role permissions within SQL Server.
It appears to be related to the level of privilege for the current user's
Windows account.
This is the KB article that refers to error 8198 state 24 and it's meaning ;
http://support.microsoft.com/?kbid=834124
I have granted execute on xp_logininfo to Public.
The Windows account is a member of Users, Domain Users and Remote Desktop
Users.
If I create a SQL login for an account with this group membership profile
and attempt to run
exec master..xp_logininfo '[domain\user]', 'all'
I get the error.
SQL Server is running on Windows 2003 Server.
PDC is running on another instance of Windows 2003 Server.
-- Regards, Craig "Andy Davis" wrote: > Hi, > have you tried as i suggest ? > > > Regards > -- > Andy Davis > Activecrypt Team > -------------------------------------------- > SQL Server Encryption Software > http://www.activecrypt.com > > > > "Andy Davis" wrote: > > > Hi, > > its enough for users to have execute permission for SP, it should work. > > About Error 8918 , its here: > > Could not obtain information about Windows NT group/user '%ls' > > > > Please refer this script , it will give information for user with role and > > rights > > http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10504 > > > > Regards > > -- > > Andy Davis > > Active Crypt Team > > --------------------------------------------SQL Server Encryption > > Decryption Software > > http://www.activecrypt.com > > > > > > > > "Craig" wrote: > > > > > Hi > > > I am trying to obtain all permission paths for a SQL Login (Windows domain > > > account) using xp_logininfo. > > > > > > The user running the query has been granted execute on the procedure but > > > gets error 8198 with state 24, which I have determined to mean 'Access > > > Denied'. > > > > > > What I would like to know is what level of privilege or permission(s) does > > > this user > > > require at the operating system level to be able to get a result? > > > > > > The online books don't mention this in the permissions section. > > > > > > Thanks. > > > > > > -- > > > Regards, > > > Craig
- Next message: Andy Davis: "Re: Setting SQL Permissions - please respond to this simple questi"
- Previous message: Uri Dimant: "Re: User can't access his own objects"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
