through "Enterprise Manager" on an existing users of a
database.
The "login name" has been created but I need to effect the
changes on the users. An example is either to either add
or change the "login name" of the user "dbo".
Advise would be appreciated.There is no way that I know of to edit the login name of a login through EM.
From your post, are you trying to change the dbo of the database? If so,
look at sp_changedbowner
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"topokin" <bimosekin@.hotmail.com> wrote in message
news:021901c3c540$546acc90$a001280a@.phx.gbl...
quote:|||You can change the login name of the dbo with the sp_changedbowner
> How is it possible to add or modify "login name"
> through "Enterprise Manager" on an existing users of a
> database.
> The "login name" has been created but I need to effect the
> changes on the users. An example is either to either add
> or change the "login name" of the user "dbo".
> Advise would be appreciated.
procedure, but you cannot change the login name that current exists for the
dbo.
Rand
This posting is provided "as is" with no warranties and confers no rights.
No comments:
Post a Comment