Re: Account Dropped but Public Role still shows account?

From: John Rugo (jjrugo_at_patmedia.net)
Date: 10/24/03 

Date: Fri, 24 Oct 2003 13:39:14 -0400

Yes that would make sense.
Thanks for the help!

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:i69gpvk4cj61ae8s66h51rgu7c3rshavtc@4ax.com...
> I'm not sure where you are looking at this - server roles or
> database roles? A user can have another name in a database -
> look at sp_add_user in books online for an example of this.
> If you have one with a different user name in a database,
> there was likely some difference in how, when, where the
> user was added.
>
> -Sue
>
> On Thu, 23 Oct 2003 10:42:24 -0400, "John Rugo"
> <jjrugo@patmedia.net> wrote:
>
> >It is was a Windows Authentication Login; and it is working now.
> >I waited about an hour; just by chance, I had other things to do. Came
back
> >and recreated the same account and it went in fine. I don't know why but
> >I'm glad it did.
> >
> >While I have your attention though:
> >Can you tell me why, when adding Login's to roles, all of the names lack
the
> >DomainName\ in front of it accept for one user. I created them all the
same
> >and they are all showing the DomainName\ in Logins?
> >
> >Thanks for you help,
> >John.
> >
> >
> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> >news:m8lfpvct4g04rkktg5gs9eq00pbd6h4gu0@4ax.com...
> >> If this is a SQL login, take a look at using
> >> sp_change_users_login to fix the problems with the login.
> >> You can then go through the appropriate steps to drop the
> >> user then drop the login if needed.
> >> If this isn't the case, please post more information such as
> >> the error number and error message you get when you try to
> >> create the login, if you are doing this in QA or EM, etc.
> >>
> >> -Sue
> >>
> >> On Thu, 23 Oct 2003 09:10:59 -0400, "John Rugo"
> >> <jjrugo@patmedia.net> wrote:
> >>
> >> >Hi All,
> >> >
> >> >I have an account that was dropped from a SQL Server.
> >> >Under the Public Role of a database this account is still showing up.
It
> >is
> >> >causing a problem I think, where I am trying to recreate the same
account
> >on
> >> >the server.
> >> >
> >> >Can anyone help me get rid of this please.
> >> >
> >> >Thanks,
> >> >John.
> >> >
> >>
> >
>

Relevant Pages

  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account will ... Create one or more logins for the applications. ... for each database. ... , you really have no security for your ...
    (microsoft.public.sqlserver.security)
  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account ... A new DBA Admin User login would only be useful for SQL Login purposes. ... if appropriate you can add users to the db_owner role in a database. ... Create one or more logins for the applications. ...
    (microsoft.public.sqlserver.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: Changing security authentication type.
    ... Create one or more logins for the applications. ... each database. ... You want to eventually remove any application usage of the sa account. ... So in short you're saying to keep the "mixed" authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: Best way to parse file into db-type layout?
    ... That's an awful lot of columns to put into a database table, ... The rows are identified by Letter type and an account number (always the ... Off to search for dictionaries and databases now. ... > What you need is a clear appreciation of what you are trying to do ...
    (comp.lang.python)
Quantcast