February 23, 2011 at 5:20 pm
I had sent a request to my web host that houses my SQL Server 2008 database. The request was to be granted ALTER TRACE permission so that I can run a trace on my database. Here is the reply I got from them:
It is not possible to assign ALTER TRACE permission in a shared server (your user will then have SA privileges which isn't allowed in shared servers).
I have always been under the impression that you could grant the individual ALTER TRACE permission without receiving SA privileges.
Any additional insight on this topic? Am I wrong in my thinking?
Thanks in advance!
February 23, 2011 at 9:49 pm
Alter trace does not mean sa privileges. It's a permission like any other and can be assigned to anyone.
However, since it's shared hosting I can understand the concern, just not the way it's been described. With alter trace you'll be able to trace activity on any database on the server, not just yours. It's a server-level permission, not a database level permission.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply