Grant permition an object - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Grant permition an object

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2010-06-11 : 09:58:46

Hi,

how to Deny and grant permission of an object in sql server 2005.
i am using this but got error.

GRANT EXECUTE ON Test1 TO chetuiwk270\sql2005.chetu;

where:-
Table name: Test1
Server name:-chetuiwk270\sql2005
user name:chetu

Error occure:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '\'.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-11 : 10:02:27

It is not getting better with duplicate posts.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145903

No, you're never too old to Yak'n'Roll if you're too young to die.