Re: login and password administration

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dan D. (DanD_at_discussions.microsoft.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 07:09:03 -0700

I'm not sure I know what you mean. I tried to create a user called 'sauser'
in the database using the 'sa' login and I got an error. I'm sure I've seen
'sa' as a user in a database before. How did it get there if I can't add it
as a user?

Thanks,

"Mark Allison" wrote:

> You need to use the database user name, not the login name.
>
> Mark.
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> Dan D. wrote:
> > After adding the current owner of the object, now I get this error message:
> > Server: Msg 15410, Level 11, State 1, Procedure sp_changeobjectowner, Line 55
> > User or role 'sa' does not exist in this database.
> >
> > If I try to add 'sa' as a user in the database I get this message:
> > Cannot user the reserved user or role name 'sa'.
> >
> > I was able to change the owner to another user but why did I have a problem
> > with changing it to 'sa'?
> >
> > Thanks,
> > "Hari Prasad" wrote:
> >
> >
> >>Hi,
> >>
> >>Answer to your seconds question.
> >>
> >>Make the owner of the object to DBO and drop the user and then remove the
> >>login. While changing the object you have to give TABLE_OWNER.TABLE_NAME..
> >>
> >>EXEC sp_changeobjectowner 'current_table_owner.tblSVM', 'dbo'
> >>
> >>After that drop the user
> >>
> >>sp_dropuser <user_name>
> >>
> >>Drop the login
> >>
> >>sp_droplogin <login_name>
> >>
> >>Thanks
> >>Hari
> >>MCDBA
> >>
> >>
> >>
> >>"Dan D." <DanD@discussions.microsoft.com> wrote in message
> >>news:652F288B-24C3-4D9F-A616-8EA1A6840F46@microsoft.com...
> >>
> >>>Using SS2000. I have two questions. How do adminsremember passwords for
> >>>logins. We have several web sites each with its own login and password. I
> >>>thought about creating a table somewhere and storing the login, password
> >>
> >>and
> >>
> >>>purpose of the login but that doesn't seem so secure.
> >>>
> >>>Second question - I have a login/user who I want to remove. The user owns
> >>
> >>a
> >>
> >>>table in a database. I tried changing the owner of the table to 'sa' using
> >>>"EXEC sp_changeobjectowner 'tblSVM', 'sa'" but I received this error:
> >>>Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line
> >>
> >>38
> >>
> >>>Object 'tblSVM' does not exist or is not a valid object for this
> >>
> >>operation.
> >>
> >>>How do I get rid of the login/user?
> >>>
> >>>Thanks,
> >>>--
> >>>Dan D.
> >>
> >>
> >>
>

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)