Re: sp_change_users_login use after restore

From: Ken (raidken_at_yahoo.com)
Date: 12/08/03 

Date: 8 Dec 2003 10:51:02 -0800

Dan,
 
The user was a member of the sysadmin role, once I took the role out,
the problem went away.

Thanks for the help, everyone.

Ken

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message news:<#6p8ZVGvDHA.1340@TK2MSFTNGP09.phx.gbl>...
> To add to the other responses, perhaps the login us a member of the sysadmin
> role on the new server. In that case the login will will be 'dbo' in the
> database instead of the normal userid and will need to qualify the table
> name.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
>

Relevant Pages

  • Re: Other way of Changing Password if does not have Server Role
    ... A user can change his password without being a member of the sysadmin role. ... You just have to login as the user and then omit the 3rd parameter ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: how to find out if a domain user is in the sysadmin server role?
    ... I connected with a login that is a member of a group that is a sysadmin. ... print 'Current user''s login is NOT a member of the sysadmin role' ...
    (microsoft.public.sqlserver.security)
  • Re: Check User in Role?
    ... print 'Current user''s login is NOT a member of the sysadmin role' ... Software Consultant ...
    (microsoft.public.sqlserver.programming)
  • Re: SA password recovery
    ... >You can connect using Query Analyzer as a sysadmin role ... >trusted connection by a member of the local admin group) ... >SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: sp_revoke login is not working as expected.
    ... EXEC xp_logininfo 'MyDomain\SomeUserAccount','members' ... Try specifying a group member rather than the group. ... This should list the Windows groups the user can connect with. ... connect with the non-existing login. ...
    (microsoft.public.sqlserver.security)