Re: Grant Access Error

Use brackets as delimiters:

GRANT <privileges> on <table_name> TO [gh.om]

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Leif S" <LeifS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39A5D87F-9801-4013-87CF-FD6A729AEF47@xxxxxxxxxxxxxxxx
SQL Server returns an error when I try go grant privileges to a username
containing '.' (dot). The statement goes like this:

GRANT <privileges> on <table_name> TO gh.om

The error message point to the '.' Is there a workaround?

We use the format "sitename"."username" on quite a lot of
serverconfigurations in our company and it will be quite a job to change
all
the logon ids.

Thanks for any assistance

/Leif S
--
Systems Analyst

.

Relevant Pages

  • Re: logon failure
    ... MSSQLServer service after you change the username of administrator account. ... username for the SQL Server startup service account or the SQL Server Agent ... Microsoft SQL Server service account on the SQL Server host computer. ...
    (microsoft.public.windows.server.sbs)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.inetserver.iis.security)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.win2000.security)
  • Re: Index for username/password
    ... say that users want to be able to define customer ... A username in a login table is a little different. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Index for username/password
    ... id int not null identity constraint sk_logon unique clustered, ... logon_id int not null references Logon, ... Say you want to display list which includes the username. ... > Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)