Member Avatar for kikisses
kikisses 0 Newbie Poster

Hi,

When i change my function, change the return itens (when it returns a table), i lose grants that i had on it...

Exemple:

alter function dbo.up_xxx (@cod_instc int)
returns @teste table (cod_instc_usr int,  COD_INSTC_prod int)
AS
BEGIN return END

Is there a way not to lose it?


Thanks

  • 1 Contributor
  • 0 Replies
  • 50 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.