Sp_helplogins Permissions

Apr 8, 2004

Hello,

I have a user u with server role security admin. I use sql2000. I go the query analyzer and call sp_helplogins. Now I get all the logins with attached users. Perfect! When i'm in my sourcecode(C++ and i use sqloledb.dll) and I make a call to sp_helplogins I get now results. Why is this? When I also give user u the fixed server role system admin it also works in my code. But in sql server help file it says the following:

Permissions
Only members of the sysadmin and securityadmin fixed server roles can execute sp_helplogins.

So it should be enough to have only one of these two roles. Does anyone have a clue why I don't get result when I call sp_helplogins from my code. I don't want to give system admin tights to user u.

beforehand thanks

Coen Dunnink
The Netherlands

View 2 Replies

Sp_helplogins

Jun 21, 2006

I tryning to program (in VB.net) sp_helplogins, assuming this is the correct sp to use to determine who is currently logged onto the database.

Ive already programmed, in VB.net, the execution of sp_helpuser and get correct results, but don't seem to be able to program sp_helplogins.

Any help would be appreciated.

Thanks,

/jerry

View 13 Replies View Related

SP_HELPLOGINS Help

Sep 12, 2007

I am trying to send the output from sp_helplogins to a table, however, whenever I run it the results come in two windows...Does anybody get what I mean? Generally, I would just create the table, then send the results to the table, however, there are two outputs from the stored proceedure, with me wanting both...What can I do to send these results to a table? Please run sp_helplogins to get a better understanding of what I mean. Thanks in advance for any help.

-Kyle

View 2 Replies View Related

Sp_helplogins

Sep 12, 2007

I am trying to discern the various aspects of the t sql behind this stored proceedure. Has anybody already broken the sp down to the two different SELECT's to get the two result tables? If not, can anybody help me begin to do this?
-Kyle

View 1 Replies View Related

Permission On Sp_helplogins

Jan 28, 2000

We're runnning SP5A, and I logon to an a/c which map to the public group in the master db, if I execute sp_helpprotect on stored procedure sp_helplog and sp_helplogins, both of them indicates permissions to execute is granted to public.
Owner Object Grantee Grantor ProtectType Action Column
----- ------------- ------- ------- ----------- ------- ------
dbo sp_helplogins public dbo Grant Execute .

I have no problem in executing sp_helplog, however, when I tried to execute
sp_helplogin, I got
"Msg 15003, Level 16, State 1
You must be System Administrator (SA) to execute this stored procedure."

Anyone knows why ??? I thought the sysprotects system table is where to control permission to execute stored procedure, is this an exception...
Thanks.

View 2 Replies View Related

Sp_helplogins Stored Proc.

Dec 4, 1998

Could someone help me understand the following code from the sp_helpsyslogins
stored procedure?

SELECT
@charMaxLenLoginName =
convert ( varchar
,isnull ( max(datalength(LoginName)) ,9)
)
,@charMaxLenDBName =
convert ( varchar
,isnull ( max(datalength(DBName)) ,6)
)
,@charMaxLenUserName =
convert ( varchar
,isnull ( max(datalength(UserName)) ,8)
)

I do not understand what the last parameter of the convert function
(the
9, 6, & 8) represents nor how it's value gets determined.
Could you possibly shed some light on this for me. I would like to
modify this procedure to also include group name for each login with in
a
database.

View 1 Replies View Related

Table Permissions Versus View Permissions

Aug 2, 2006

Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.