Hi, We are getting the error - user does not have permission to run dbcc auditevent - when the user executes sp_password stored procedure. The user is part of public group in master database. dbcc auditevent is used throughout the procedure. I know some priviledge / permisssion is missing, but what ? Any clues ? Thanks
Have you made any changes to system stored procedures? I remember some issues with that but thought it was more related to sp_addlogin and people "customizing" that. I vaguely remember something with this error when it's a user who is a member of the securityadmin role trying to make changes...can't remember all the details. -Sue On 18 Oct 2005 08:04:04 -0700, hellovora@gmail.com wrote: >Hi, >We are getting the error - user does not have permission to run dbcc >auditevent - when the user executes sp_password stored procedure. The >user is part of public group in master database. >dbcc auditevent is used throughout the procedure. I know some >priviledge / permisssion is missing, but what ? >Any clues ? >Thanks
