Re: orphaned 'aliased' user

From: Peter Feakins (PeterFeakins_at_discussions.microsoft.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 13:49:05 -0700

We found that if we dropped the login (login was only mapped to the one
database) then we could run sp_dropalias successfully. Thanks for the help.

Peter

"Russell Fields" wrote:

> Peter,
>
> From your comments you certainly seem to know about the topic
> Troubleshooting Orphaned Users (BOL)
> http://tinyurl.com/7yjwt
>
> It seems like you may be stuck with the ugly process of hacking the system
> table to fix this. (Not too bad in this case, but to be avoided as a general
> policy.) You should be able to allow updates to system tables, then delete
> the troublesome row. Then be sure to disallow updates again.
>
> allow updates Option (from the BOL)
> http://tinyurl.com/4juy2
>
> Russell Fields
>
> "Peter Feakins" <PeterFeakins@discussions.microsoft.com> wrote in message
> news:6962B92D-1ED2-4A69-8B30-7DC9D704C8DD@microsoft.com...
> > We have a database that we detached and reattached on a new server. We've
> > corrected all of the orphaned users except for one that appears to be an
> > alias. The value for 'isaliased' in sysusers is 1 and the value for issql
> is
> > 0. We've transferred the login with which it was originally associated,
> > however, the sid value has changed. It appears that we can't use
> > sp_change_users_login since the user is not an sql user, and the
> sp_addalias
> > inserts a new sysusers record, rather than update the existing record.
> Any
> > suggestions?
>
>
>

Relevant Pages

  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)