Re: GRANT VIEW ANY DEFINITION to Windows Auth Account

Hello,

Try this:
GRANT VIEW ANY DEFINITION TO [EKREM-PC\Ekrem]

--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT



"DSM_DBA" <dsmdba@xxxxxxxxxxx> wrote in message news:F9F9D8CE-017F-4998-8A9E-F05FE5B3196E@xxxxxxxxxxxxxxxx
I realize this is probably simple, but I'm not able to do the grant statement
and make it work on a Windows Authentication login.
It works fine for SQL logins such as
GRANT VIEW ANY DEFINITION to SQLUserName
but how should it be for
GRANT VIEW ANY DEFINITION to Domain\User? I've tried it that way, with quotes
GRANT VIEW ANY DEFINITION to 'Domain\User' and I'm not sure what else to try.
Any help for my issue would be greatly appreciated.
Thanks,


.

Relevant Pages

  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: user defined Role - HELP
    ... Grant ALTER TABLE on tblReportNums to 'UM Case Mgmt' ... Grant the role ALTER permission on the table. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie to security
    ... Use sp_grantdbaccess to grant access to the database. ... databases when you are new to security. ... Microsoft SQL Server 2000 SP3 Security Features and Best ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Express
    ... GRANT them permissions to do so with the GRANT command. ... GRANT CREATE DATABASE on DATABASE::xxx to SAM ... Yes, I am very familiar with configuring specific SQL Server accounts for access, and I am having no real problems in this area. ... really a good way to block administrator access without making your database pretty hard to administer. ...
    (microsoft.public.sqlserver.msde)
  • Re: user defined Role - HELP
    ... SQL Server MVP ... I get an error "Privilege ALTER TABLE may not be granted or revoked. ... Grant ALTER TABLE on tblReportNums to 'UM Case Mgmt' ... Grant the role ALTER permission on the table. ...
    (microsoft.public.sqlserver.security)