User DBO

Question

Hi Team,

One of the user has database owner access now

User looking on to check the trace on the profilesr

what permissions we will give to that user.

Tx

---

subu

Answer 1

http://msdn.microsoft.com/en-us/library/ms190362.aspx   User must have ALTER TRACE permission.

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Hi Subu,

which version of SQL server it in on? ALTER TRACE will work for SQL 2005 or higher version, for SQL 2000 and lower version it require sysadmin server level role.

---

Kindly mark the reply as answer if they help

Answer 3

it sql server 2008 R2

---

subu

Answer 4

OK, it require ALTER TRACE permissions. You can grant this permission using below TSQL.

Use Master,
go
Grant Alter Trace to <LoginName>

---

Kindly mark the reply as answer if they help

Answer 5

Hi Thanks it is resloved.

---

subu