SQL Server: The object 'Tb_DotnetFunda' does not exist in database 'DotnetFunda' or is invalid...

Posted by PandianS under Error and Solution on 12/16/2010 | Points: 10 | Views : 4274 | Status : [Member] [MVP] | Replies : 1

.
.
When I try to perform the following action
Sp_Help Tb_DotnetFunda
The error occurred "The object 'Tb_DotnetFunda' does not exist in database 'DotnetFunda' or is invalid for this operation."

The reason may be anyone of the following

The table(Tb_DotnetFunda) may not be available on 'DotnetFunda' database.
(or)
The current user does not have permission to describe/expand the table structure.

When you use Sp_Help Tb_DotnetFunda, The current user should have VIEW DEFINITION permission on this Object.

How to identify whether the current user has the appropriate permission or not:
SELECT	Has_Perms_By_Name(N'dbo.Tb_DotnetFunda', 'Object', 'VIEW DEFINITION') as 'Permission'
Permission
----------
0

Login as a SysAdmin (sa)

Grant permission to perform this action:
GRANT VIEW DEFINITION on Tb_DotnetFunda TO <User Name>
Now, the user can perform the action...

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions



Responses

Posted by: T.saravanan on: 12/16/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi PandianS,

Thanks for your knowledge sharing.It's really helpful to anyone.


Thanks,
T.Saravanan

PandianS, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response