Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004

    Unanswered: Error on Adding New Server Login

    When I tried to add a new login to the server and after assigning DB Roles,
    I am getting the error message that the role has been already added to the user. I think this username has already been in the system earlier. It is in the sysuser table. I tried to delete the roles to which this user has permissions. But still I am getting this error. I am not sure where else it is stored. How can I delete this username completely from all Databases and reassign this userid in the server.
    Please advise.
    Last edited by arunaraj; 10-11-04 at 16:25.

  2. #2
    Join Date
    Nov 2002
    You're trying to modify system tables...hmmmmmmmmm

    What other type of work do you do?

    Look at system stored procs sp_dropuser and sp_droplogin

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2004
    I am not modifying the system tables. I am trying to add a new user.
    But it is not letting me do that as this user already exists in the sysuser table. I executed sp_dropuser 'test' and sp_droplogin 'test'. But still getting the same error when I tried to add this userid and assigned DB roles(I am doing for all 4 DBs at a time).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts