Re: SQL Profiler and SP-4 Traces (-- The text has been replaced with t

With SP 4, the SQL Trace API will scan for "password" and
mask the text if password is found - as well as doing so for
some security related stored procedures. Prior to that I
think it may have limited it to some of the security system
stored procedures (sp_password, sp_addlogin, etc). I'm not
aware of any setting that turns this off.

-Sue

On Fri, 16 Jun 2006 06:58:02 -0700, Brian Goldberg
<BrianGoldberg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

We are tracing our application and in the Text Data we get "-- 'password' was
found in the text of this event.
-- The text has been replaced with this comment for security reasons."

Now we can not see the details of this code.....

We are looking for a way to turn this off, like in SP-3 & SP-3a.....

.

Relevant Pages

  • Problems with create mask and security mask in SAMBA configuration
    ... directory security mask = 0777 ... force directory security mode = 0 ...
    (Debian-User)
  • RE: besides "sa" who can run xp_cmdshell
    ... users to execute stored procedures and extended stored procedures. ... You can find out the current permissions by running 'sp_helprotect' stored ... Is there a way to determine which accounts (other than ... This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)
  • sp_oacreate security execute problem
    ... but am restricted via security policies on certain system ... Here's the sql code first of all: ... level so I set all related system stored procedures to ... provider to set the effective settings to Service, ...
    (microsoft.public.sqlserver.security)
  • Get NT Logged User in Stored Procedure
    ... I'm not a security expert. ... only to those stored procedures you will need. ... between the sql server and the web server with ssl, ... a complete security solution - you'll have to carefully ...
    (microsoft.public.dotnet.security)
  • Re: security and stored procedures
    ... A number of different factors contribute to the security of a stored ... underlying table rights in order to run the procedure. ... Stored procedures are excellent tools to ensure the security of the ... if you use dynamic SQL in your procedure all bets ...
    (microsoft.public.sqlserver.programming)