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 |
|
puri
Starting Member
1 Post |
 Posted - 2004-07-23 : 01:28:56
|
| hi My sqlserver is installed with windows authentication.When i execute select select replace(dbo.FormatNumber (cast(round(c,2,0) as numeric), '2', '(,', '0') ,'{ERR-null passed}','') as 'Unit' from x its saying Server: Msg 229, Level 14, State 5, Line 1 EXECUTE permission denied on object 'FormatNumber', database 'APr, owner 'dbo'. how to give this permissions i tried this grant EXECUTE on dbo.FormatNumber to public but saying Invalid object name 'dbo.FormatNumber'. If i give db_owner previlige to perticular user query is working fine but i dont want to give db_owner previlige to akk users.I just want to give exec permissions to FormatNumber function for all valid sql users.pl help me |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-23 : 04:03:15
|
| If this is dynamic SQL then the user needs permissions to the underlying tables.Easiest way to give that on ALL tables (but inherently insecure of course) is add the user to the db_datareader and/or db_datawriter rolesKristen |
 |
|
|
|
|
|
urgent pl giving exec permissions to function