Re: Permissions lost after alter table-valued function
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/05/05
- Next message: djc: "Re: simple security question (need refresher)"
- Previous message: Dan Guzman: "Re: simple security question (need refresher)"
- In reply to: Micle: "Re: Permissions lost after alter table-valued function"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 5 Oct 2005 08:13:50 -0500
I believe the applies to list should include the other SQL 2000 editions as
well. I submitted this feedback using the form at the bottom of the page.
-- Hope this helps. Dan Guzman SQL Server MVP "Micle" <micle@netlab.ru> wrote in message news:O6$cJoayFHA.3856@tk2msftngp13.phx.gbl... > Hi! > > Applies to section in bug description: > > Microsoft SQL Server Standard Edition. > > Our version: > > select @@version > > Result: > > Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) > May 13 2005 18:33:17 > Copyright (c) 1988-2003 Microsoft Corporation > Enterprise Edition on Windows NT 5.2 (Build 3790: ) > > Micle. > > > "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message > news:ue32OkayFHA.2880@TK2MSFTNGP12.phx.gbl... >> This looks like the bug described in MSKB 888530: >> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;888530 >> >> -- >> Hope this helps. >> >> Dan Guzman >> SQL Server MVP >> >> "Micle" <micle@netlab.ru> wrote in message >> news:%23S3GNfayFHA.2516@TK2MSFTNGP12.phx.gbl... >>> create function dbo.tfFoo() >>> returns @t table >>> ( >>> ID int >>> ) >>> as >>> begin >>> insert into @t(ID) >>> values(1); >>> >>> return; >>> end >>> GO >>> grant select on dbo.tfFoo to public >>> GO >>> select object_id('dbo.tfFoo') >>> select id from syspermissions where id = object_id('dbo.tfFoo') >>> select id from sysprotects where id = object_id('dbo.tfFoo') >>> GO >>> alter function dbo.tfFoo() >>> returns @t table >>> ( >>> ID int >>> ) >>> as >>> begin >>> insert into @t(ID) >>> values(1); >>> >>> return; >>> end >>> GO >>> select object_id('dbo.tfFoo') >>> select id from syspermissions where id = object_id('dbo.tfFoo') >>> select id from sysprotects where id = object_id('dbo.tfFoo') >>> GO >>> drop function dbo.tfFoo >>> GO >>> >>> Result >>> >>> >>> ----------- >>> 661785615 >>> >>> (1 row(s) affected) >>> >>> id >>> ----------- >>> 661785615 >>> >>> (1 row(s) affected) >>> >>> id >>> ----------- >>> 661785615 >>> >>> (1 row(s) affected) >>> >>> >>> ----------- >>> 661785615 >>> >>> (1 row(s) affected) >>> >>> id >>> ----------- >>> >>> (0 row(s) affected) >>> >>> id >>> ----------- >>> >>> (0 row(s) affected) >>> >>> Permissions are lost. >>> >>> Micle. >>> >>> >>> >> >> > >
- Next message: djc: "Re: simple security question (need refresher)"
- Previous message: Dan Guzman: "Re: simple security question (need refresher)"
- In reply to: Micle: "Re: Permissions lost after alter table-valued function"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
