Re: Verfiying Securityhotfix.sql
From: Arvind Krishnan[MS] (arvindk@online.microsoft.com)
Date: 10/14/02
- Next message: Arvind Krishnan[MS]: "Re: SP4 on SQL 7.0"
- Previous message: Raju: "Converting a database from dictionary case insensitive sort order to binary sort order"
- In reply to: Dave S: "Verfiying Securityhotfix.sql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Arvind Krishnan[MS]" <arvindk@online.microsoft.com> Date: Mon, 14 Oct 2002 14:12:37 -0700
Dave,
You can try running the following query against your msdb database and see
if the permissions have indeed been revoked?
use msdb
go
sp_helprotect mswebtasks
Thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
Arvind Krishnan
SQL Server Development Team
Microsoft Corporation
"Dave S" <dsparks@stbernardsoftware.com> wrote in message
news:1dd401c273ba$2127c140$37ef2ecf@TKMSFTNGXA13...
> How can I determine if the revoke statements where
> executed in the query that came with the latest security
> rollup for SQL 7 sp4. I can find the objects in the
> sysobjects table but I can not tell if they are public or
> not.
- Next message: Arvind Krishnan[MS]: "Re: SP4 on SQL 7.0"
- Previous message: Raju: "Converting a database from dictionary case insensitive sort order to binary sort order"
- In reply to: Dave S: "Verfiying Securityhotfix.sql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
