Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2007-11-19 : 11:14:28
|
| Hi everyone,I am trying to create a UDF, the creation works fine -but i cannot set the EXEC permission...I see the column, but there is no checkbox that will allowit to be executed.In other UDFs, the checkbox is there and I can remove and replace the EXEC permission, just not in the newly created UDFANyone have any ideas on this??thankstony |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-11-19 : 12:11:56
|
| did you create it with dbo as the owner? CREATE FUNCTION dbo.SomeFunction(...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-19 : 14:51:57
|
| yes |
|
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-19 : 15:09:14
|
| is there an error trying to use tsql?GRANT EXECUTE ON [dbo].[somefunction] TO [guest]GO |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-19 : 16:18:53
|
| tried that as well....Server: Msg 4606, Level 16, State 1, Line 1Granted or revoked privilege EXECUTE is not compatible with object. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-19 : 16:27:49
|
| What kind of UDF is it? If it's a table function, then you grant SELECT on it and not EXEC.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-20 : 08:18:22
|
| Hi Tara and everyone,After review, it is a table based return.thanks for your helptake caretony |
|
|
|
|
|
|
EXEC permission on UDF