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

Try putting square brackets around the domain and login.

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

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"ezeget.com" <ezeget.com2007@xxxxxxxxxxxxxxxx> wrote in message news:DDCA9984-E67D-45EC-BAB0-0B3BBE54FBF8@xxxxxxxxxxxxxxxx
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

--
Steve G

.

Relevant Pages

  • Re: Parameter for Stored Procedure
    ... Incorrect syntax near '@ClientDBName'. ... FILENAME = N''C:\Program Files\Microsoft SQL ... MAXSIZE = UNLIMITED, ... FILEGROWTH = 1024KB) ...
    (comp.databases.ms-sqlserver)
  • strange errors in execute sql task
    ... while executing "execute sql" tasks. ... Incorrect syntax near "1" ... uninstalling & installing sql server didn't help. ...
    (microsoft.public.sqlserver.dts)
  • strange errors with dts and sql
    ... while executing "execute sql" tasks. ... Incorrect syntax near "1" ... uninstalling & installing sql server didn't help. ...
    (microsoft.public.sqlserver.server)
  • Re: Reset permissions
    ... undocumented APIs in production code. ... I recommend building some simple code generators like the one shown below. ... GRANT EXECUTE ON SCHEMA:: someschema TO someuser ... SQL Server Engine ...
    (microsoft.public.sqlserver.security)
  • Re: Urgent: Permissions Problem with Dynamic SQL
    ... > having problems with permissions when using dynamic sql. ... > CREATE PROC a2 AS ... > GRANT EXECUTE ON a2 TO user1 ...
    (microsoft.public.sqlserver.security)