Wednesday, March 7, 2012

MS SQL 2005. GRANT.

Good afternoon!
I have given privileges to Windows security group
GRANT ALTER TRACE TO "dev \g_developers"
After that members of this group cannot start Profiler successfully.
Later i has given the rights to the user "dev \vivanov"
GRANT ALTER TRACE TO "dev \vivanov"
The user has executed Profiler successfully.
What can be wrong?Support for SQL Server 2005 Beta/CTP in the SQL Server 2005 Communities:
http://communities.microsoft.com/ne...p=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roman M" wrote:

> Good afternoon!
> I have given privileges to Windows security group
> GRANT ALTER TRACE TO "dev \g_developers"
> After that members of this group cannot start Profiler successfully.
> Later i has given the rights to the user "dev \vivanov"
> GRANT ALTER TRACE TO "dev \vivanov"
> The user has executed Profiler successfully.
> What can be wrong?
>

No comments:

Post a Comment