I created users with login option in security tab in sql server 2008 R2 running on windows 7 successfully and grant permissions to :
Grant REFERENCES ON OBJECT::vuUser TO nvp
Deny INSERT,SELECT,UPDATE,DELETE ON OBJECT::dummyDB.userTb to nvp
nvp user can login successfuly and resctriction work great but when i create user and grant permissions as above on sql serevr 2008 R2 running on windows server 2008.User login successfully but when i try to grant permission using above code,it says:
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'usertb', because it does not exist or you do not have permission.
Is their is something I am doing wrong or I need to try something else ?????
database+table name is correct...
Need urgent help n thanks in advance