Results 1 to 4 of 4

Thread: removing user

  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: removing user

    Hello,
    I have a problem with removing an user on a SQLSERVER V7 base.

    I can suppress the user, but it still exist for the role PUBLIC.

    Can you help me ?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Do you mean that you remove the user from the database, but they can still get in through Public, or are you getting an error when you try to delete the user?

    blindman

  3. #3
    Join Date
    Aug 2003
    Posts
    5

    Re: removing user

    Hi...
    What u mean by suppress the user...? What errror message u r getting?
    U can remove user from User Roles still it will exists in Public. Do the user owns some objects ? guests are allowed in the DB ?

    Cheers

    Shaji

    Originally posted by jleb
    Hello,
    I have a problem with removing an user on a SQLSERVER V7 base.

    I can suppress the user, but it still exist for the role PUBLIC.

    Can you help me ?

  4. #4
    Join Date
    Aug 2003
    Posts
    62
    I remove the user from the database, but it still exists whem I look the Public role.

    Thank you fopr your help, I have found a solution with the command sp_revokedbaccess.



    Originally posted by blindman
    Do you mean that you remove the user from the database, but they can still get in through Public, or are you getting an error when you try to delete the user?

    blindman

Posting Permissions

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