SQL 2000 SP3 addrolemember problem

From: Shep (dbashep@yahoo.com)
Date: 03/26/03 

From: "Shep" <dbashep@yahoo.com>
Date: Wed, 26 Mar 2003 10:50:24 -0800

My security admin team is getting the following error when
trying to add a user to a role;

Server: Msg 229, Level 14, State 5, Procedure
sp_addrolemember, Line 95
UPDATE permission denied on object 'sysusers',
database 'Database9', owner 'dbo'.

The UserID is a member of db_accessadmin, db_securityadmin
on the database as well as SecurityAdministrator Fixed
Server Role. This problem is occuring only on a few
databases out of several hundred my group supports, Also
the problem seems to follow the database. If I relaod the
database to another server and recreate the security ids
the problem still exists. Interestingly enough this
started after the SQL2000 SP3 rollout. NO other changes
have been made to the servers or databases. Any
thoughts????

Shep

Relevant Pages

  • Re: SceCli Error 1202 filling up the Event Log!
    ... > after restarting the Win2003 server, the secedit.sdb database does not get ... >>> security database and have it recreated. ... >>> configuration\windows settings\security settings, you should inventory ...
    (microsoft.public.win2000.advanced_server)
  • RE: Script for find dominos users
    ... The key lies in the fact that Domino web servers will ... "404" nonexistent URI if the database does not. ... Choose not to allow email through the web (Application Security, ... server's server document. ...
    (Bugtraq)
  • Re: Newbie Salt and Pass Phrase Question.
    ... is it a server side application? ... The database contains private ... The second biggest problem confronting me is that security was ... My client, a tennis coach, tells me other coaches at the same ...
    (sci.crypt)
  • Re: Is this possible??
    ... The OwnerAccess option is used with user level security - which is only ... the application from the beginning using client/server concepts such as ... You would keep the back end database on the server where only ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using SSPI with Custom Authentication
    ... It boils down to moving the security perimeter away from the server. ... first database contains all of the user information; ... perform authentication, and users need to be authenticated before accessing ...
    (microsoft.public.dotnet.security)