When I try to perform the following action
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'
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...