Permissions lost after alter table-valued function
From: Micle (micle_at_netlab.ru)
Date: 10/05/05
- Next message: Dan Guzman: "Re: Permissions lost after alter table-valued function"
- Previous message: djc: "simple security question (need refresher)"
- Next in thread: Dan Guzman: "Re: Permissions lost after alter table-valued function"
- Reply: Dan Guzman: "Re: Permissions lost after alter table-valued function"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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.
- Next message: Dan Guzman: "Re: Permissions lost after alter table-valued function"
- Previous message: djc: "simple security question (need refresher)"
- Next in thread: Dan Guzman: "Re: Permissions lost after alter table-valued function"
- Reply: Dan Guzman: "Re: Permissions lost after alter table-valued function"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
