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 |
|
swathigardas
Posting Yak Master
149 Posts |
 Posted - 2009-01-07 : 06:57:55
|
| Hi I have Created a Function called [VIMS_User].[FUNC_Get_SubCategory_Values] in the DB using [VIMS_User] login.The next day i have right clicked on the function and clicked modify (or ) or trying to generate the script.. i get the following error - Script Failed for User Defined Function : [VIMS_User].[FUNC_Get_SubCategory_Values]Additional Information : Property Quoted Identifier Status is not available for User Defined Function '[VIMS_User].[FUNC_Get_SubCategory_Values]'. This Property may not exist for this object, or may not be retrievable due to insufficient access rights. [Microsoft.SQLServer.smo]Can anyone please tell me why i am unable to access the function, despite of logging in as [Vims_User].Thanks Before Hand |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 07:00:47
|
Is Vims_User dbo? Do Vims_User have EXECUTE rights for function above?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
swathigardas
Posting Yak Master
149 Posts |
Posted - 2009-01-08 : 00:18:10
|
| yes vims_user has the execute permissions on the function.. i executed it.. it gave perfect result..But still the same above problem is been shown |
|
|
|
swathigardas
Posting Yak Master
149 Posts |
Posted - 2009-01-09 : 02:10:59
|
| Please can anyone tell me whats the cause of this error message.. Please tell me do i need to post any additional info |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 09:46:57
|
quote:
Originally posted by swathigardas
yes vims_user has the execute permissions on the function.. i executed it.. it gave perfect result..But still the same above problem is been shown
You need View definition permission to access the functions for user. |
|
|
|
swathigardas
Posting Yak Master
149 Posts |
Posted - 2009-01-12 : 05:19:26
|
| I tried Granting view definition permission to vims_user by using the following syntax - Grant view definition on [vims_user.FUNC_Get_SubCategory_Values] to vims_userBut i've got an error-Msg 156, Level 15, State 1, Line 1Incorrect syntax near the keyword 'view'.Is there any mistake in the syntax. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 08:24:48
|
| Right click the function -Properties - Give Execute and View Definition permission to user. |
|
|
|
|
|
|
insufficient Access Rights