sp_adduser

hi,
I have created a new user and made it a member of 3 roles. db_owner,
db_securityadmin and db_accessadmin.

Now with this new user i am trying to create a new user using sp_adduser
procedure. But unfortunately i am getting one error

"User does not have permission to run DBCC auditevent"

Can you please help me resolve this.

Munish Narula (munish.narula@wipro.com) writes:
> I have created a new user and made it a member of 3 roles. db_owner,
> db_securityadmin and db_accessadmin.
>
> Now with this new user i am trying to create a new user using sp_adduser
> procedure. But unfortunately i am getting one error
>
> "User does not have permission to run DBCC auditevent"
>
> Can you please help me resolve this.

Weren't you using SQL 2005? In such case, why don' use CREATE USER
and assign the user the permission ALTER ANY USER?


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx