Permissions lost after alter table-valued function

From: Micle (micle_at_netlab.ru)
Date: 10/05/05


Date: Wed, 5 Oct 2005 16:24:57 +0400

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.



Relevant Pages

  • Re: [Xen-devel] [PATCH 5 of 5] xen pci platform device driver
    ... this patch adds the xen pci platform device driver that is responsible ... Few changes to xenbus and grant table are necessary to allow the delayed ... static int gnttab_free_count; ... as published by the Free Software Foundation. ...
    (Linux-Kernel)
  • [PATCH 5 of 5] xen pci platform device driver
    ... Few changes to xenbus and grant table are necessary to allow the delayed ... static int gnttab_free_count; ... * under the terms and conditions of the GNU General Public License, ... as published by the Free Software Foundation. ...
    (Linux-Kernel)
  • Re: [PATCH 06/12] xen pci platform device driver
    ... for initializing the grant table and xenbus in PV on HVM mode. ... Few changes to xenbus and grant table are necessary to allow the delayed ... Is that because the interrupt raised by a pending event is ... static int gnttab_free_count; ...
    (Linux-Kernel)
  • [PATCH 04/13] Xen PCI platform device driver
    ... for initializing the grant table and xenbus in PV on HVM mode. ... Few changes to xenbus and grant table are necessary to allow the delayed ... The Xen PCI platform device raises an irq every time an event has been ... static int gnttab_free_count; ...
    (Linux-Kernel)
  • [PATCH 05/11] Xen PCI platform device driver
    ... for initializing the grant table and xenbus in PV on HVM mode. ... Few changes to xenbus and grant table are necessary to allow the delayed ... The Xen PCI platform device raises an irq every time an event has been ... static int gnttab_free_count; ...
    (Linux-Kernel)