Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / General / Security / May 2008

Tip: Looking for answers? Try searching our database.

Problem Granting Permission to Usernames containing / or . ???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ezeget.com - 16 May 2008 13:01 GMT
Can someone explain why I am unable to do this now on my SQL Database.
Suspect it is some settings / collation or the like but when I say

GRANT EXECUTE ON functionname TO DOMAIN\Fred.bloggs

I get Incorrect syntax near \

I have tried dynamic sql and performing replace strings using CHAR() etc.

I am sure I used to be able to do this kind of thing without syntax errors?

Has anything changed in SQL??? Or am I missing something?

HELP! Please

Signature

Steve G

Reply to this Message
Andrew J. Kelly - 16 May 2008 13:09 GMT
Try putting square brackets around the domain and login.

GRANT EXECUTE ON functionname TO [DOMAIN\Fred.bloggs]

Signature

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

> Can someone explain why I am unable to do this now on my SQL Database.
> Suspect it is some settings / collation or the like but when I say
[quoted text clipped - 11 lines]
>
> HELP! Please
Reply to this Message
ezeget.com - 16 May 2008 13:31 GMT
Thanks Andrew
Now why did I not think of that.
Great service buddy
Cheers

Does it mean that the user already has permissions to execute o
Signature

Steve G

> Try putting square brackets around the domain and login.
>
[quoted text clipped - 15 lines]
> >
> > HELP! Please
Reply to this Message
Andrew J. Kelly - 16 May 2008 19:29 GMT
>>Does it mean that the user already has permissions to execute o

I am not sure what you mean by this. Can you elaborate?

Signature

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

> Thanks Andrew
> Now why did I not think of that.
[quoted text clipped - 23 lines]
>> >
>> > HELP! Please
Reply to this Message
ezeget.com - 19 May 2008 09:53 GMT
Sorry about that.

At first it looked like the granting was not actually doing anything but now
it looks like it is working. Many thanks for your assistance. Much appreciated
Signature

Steve G

> >>Does it mean that the user already has permissions to execute o
>
[quoted text clipped - 27 lines]
> >> >
> >> > HELP! Please
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.