Grant permission on object in sql server 2005

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

Transact-SQL (2005)

Grant permission on object in sql server 2005

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2010-06-11 : 08:52:41

Hi,

how i can grant select permition for a user on Table i am using syntex below

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 : 09:02:00

Only user not the server.

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

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2010-06-11 : 09:05:02

Hi,
I am using below as u suggest but got error for permission and not found object.
i am executing this commnd on that user login where i was created Test1 Table while it give error for permission.

GRANT EXECUTE ON Test1 TO chetu;

error:

Msg 15151, Level 16, State 1, Line 1
Cannot find the user 'chetu', because it does not exist or you do not have permission.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources