You do not have permission to run 'SYS.TRACES'

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

You do not have permission to run 'SYS.TRACES'

Author

Topic

mastak
Starting Member

2 Posts

Posted - 2009-02-20 : 07:18:55

Hi guys..

I have problem with creating new Login/User and then
execute under new User for example this command:
select count(*) from sys.traces

my steps:
exec sp_addlogin 'MyListener', '0', 'master' -- here might be other DB
exec sp_adduser 'MyListener', 'MyListener', 'public'
exec sp_addrolemember 'db_owner', 'MyListener'
GRANT SELECT ON SYS.TRACES TO MyListener

All my attempts with creating new User with access to sys.traces failed

Would be very happy any comments

mastak
Starting Member

2 Posts

Posted - 2009-02-20 : 16:01:30

Answer proposed by Raul Garcia:
You need ALTER TRACE permission.

GRANT ALTER TRACE TO [MyListener]

[url]http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/eef46e90-3bb1-4948-8a17-8bd58165f82c[/url]

Thanks all for attention

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources