User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 401,633 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,884 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 419 | Replies: 0
Reply
Join Date: Feb 2008
Posts: 1
Reputation: kikisses is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
kikisses kikisses is offline Offline
Newbie Poster

Function - lose grant

  #1  
Feb 12th, 2008
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
Last edited by peter_budo : Feb 13th, 2008 at 1:26 pm. Reason: Please [code] tags to separate DB query from other text
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MS SQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Other Threads in the MS SQL Forum

All times are GMT -4. The time now is 6:06 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC