Re: sysprocesses - sp_who

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David G. (david_nospam_at_nospam.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 10:22:40 -0400

anonymous@discussions.microsoft.com wrote:
> Hi David,
>
> That would indeed resolved the problem from
> QueryAnalyser... But the PowerBuilder application
> connecting to the DB is using "sa".
> The user is running the PB App which will connect to a
> COM+ Component on an Application server to authenticate
> the user, reading a USERS Table on the DB Server (using
> the Application Login which is different to the Windows
> Login). This Com+ Component will use 'sa'.
>
> The only solution we have will be to extract the Windows
> Login from the PB application and pass it to the Com+
> Component as parametter which then should be able to use
> it to connect to the Database.
> ** When we had WinNT/SQL7.0, sysprocesses was populated
> correctly (with the same Application and DB Settings).**
>
> Jerry
>> -----Original Message-----
>
>>> Jerry
>>
>> As an alternative, why not secure the "sa" login and give all
>> administrators their own logins. That way, you can easily see who is
>> who from the login name.
>>
>> --
>> David G.

That sounds like a good idea (passing login credentials). Using the "sa"
for anything but administration is a really dangerous idea. In fact, I
would usually suggest the "sa" account be locked down with a really
secure password and no one use it, except in an emergency. Admins should
have their own logins. If something should ever happen to the "sa"
account password and there were no other admin accounts, you would be in
trouble. Plus, having it in the application makes changing the password
difficult. 

-- 
David G.

Relevant Pages

  • Re: Login as root on Fedora Core 9
    ... David L. Gehrt wrote: ... login in as root, but when I do it is because a normal login followed by ... believe prohibiting local root logins does little to improve computer ... If you "have been using UNIX/linux for nearly 30 years", and I don't doubt you, you should be able to figure a way around this very easily. ...
    (Fedora)
  • Re: FormsAuthentication.GetRedirectUrl(...) Question
    ... "David Puplava" wrote in message ... > How do I change/specify the the redirect url that this ... my users click the login button ... > there something I have to do in this sub routine to set ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How doe I change su =?UTF-8?B?jA==?=
    ... David Love wrote: ... Using SuSE 10.1. ... change the login name and password for su but for the life of me ... su is root, so login as root and change the password, but please be safe and ...
    (alt.os.linux.suse)
  • Re: Action Pack - licenses
    ... "David Sherman" schreef in bericht ... Are the clients joined to the ... >>and login into the domain? ... Errormessage? ...
    (microsoft.public.windows.server.sbs)
  • Weakness introduced by denying remote logins on AIX, possibly others
    ... AIX 4.3.3 and AIX 5.1, ... is possible to remotely enumerate the passwords of a known AIX account. ... believed to be in the response from the login program after authentication ... Give accounts that have been restricted from remote logins strong passwords. ...
    (Security-Basics)