 |
|
|
|
Next: refresh data in my fields on a form
|
| Author |
Message |
External
Since: Aug 10, 2004
Posts: 12
|
(Msg. 1) Posted: Thu Jun 23, 2005 10:52 am
Post subject: question about database ownership
Archived from groups: microsoft>public>sqlserver>programming (more info?)
|
|
|
Hi everyone,
I have question about database ownership. We have a database called
"price"
"price" db was created by someone (John Doe) before, who is no longer
working for our company.
So in enterprise manager, I right-clicked on database "price" and go to
property page, I see owner as "DOMAIN\John.Doe"
but I think DOMAIN\John.Doe is not valid user anymore in our domain,
however, database is still working fine. I thought database would break
because the owner is no longer valid.... ??
I know I can change ownership by using
EXEC price..sp_changedbowner 'sa'
is there system stored procedure which returns all databases' owner
information? |
|
| Back to top |
|
 | |
External
Since: Jan 29, 2004
Posts: 891
|
(Msg. 2) Posted: Thu Jun 23, 2005 12:55 pm
Post subject: Re: question about database ownership [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
SQL Server and the database is fine with broken owner. But you don't want to leave at that.
Sp_validatelogin will list orphan Windows logins. You can use this, or code within and correlate
with sysdatabases (SID column) to list databases with orphaned Windows owners.
--
Tibor Karaszi, SQL Server MVP
<a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.karaszi.com/sqlserver/default.asp</a>
<a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/" target="_blank">http://www.solidqualitylearning.com/</a>
Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/" target="_blank">http://solidqualitylearning.com/blogs/tibor/</a>
"Britney" wrote in message
> Hi everyone,
> I have question about database ownership. We have a database called
> "price"
> "price" db was created by someone (John Doe) before, who is no longer
> working for our company.
>
> So in enterprise manager, I right-clicked on database "price" and go to
> property page, I see owner as "DOMAIN\John.Doe"
> but I think DOMAIN\John.Doe is not valid user anymore in our domain,
> however, database is still working fine. I thought database would break
> because the owner is no longer valid.... ??
>
> I know I can change ownership by using
>
> EXEC price..sp_changedbowner 'sa'
>
>
> is there system stored procedure which returns all databases' owner
> information?
>
>
>
>
>
>
>
>
> |
|
| Back to top |
|
| |
External
Since: Aug 10, 2004
Posts: 12
|
(Msg. 3) Posted: Thu Jun 23, 2005 2:27 pm
Post subject: Re: question about database ownership [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Tibor,
I see 3 window authentication accounts list as orphan windows login after I
run sp_validatelogins.
since it means those accounts don't exist in the Domain anymore, can I
drop all those logins from all the databases?
I shouldn't break anything, correct? Just want to make sure nothing break
if I drop those orphan windows login.
"Tibor Karaszi" wrote in
message
> SQL Server and the database is fine with broken owner. But you don't want
to leave at that.
>
> Sp_validatelogin will list orphan Windows logins. You can use this, or
code within and correlate
> with sysdatabases (SID column) to list databases with orphaned Windows
owners.
>
> --
> Tibor Karaszi, SQL Server MVP
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=purple> > Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
>
>
> > Hi everyone,
> > I have question about database ownership. We have a database
called
> > "price"
> > "price" db was created by someone (John Doe) before, who is no longer
> > working for our company.
> >
> > So in enterprise manager, I right-clicked on database "price" and go to
> > property page, I see owner as "DOMAIN\John.Doe"
> > but I think DOMAIN\John.Doe is not valid user anymore in our domain,
> > however, database is still working fine. I thought database would break
> > because the owner is no longer valid.... ??
> >
> > I know I can change ownership by using
> >
> > EXEC price..sp_changedbowner 'sa'
> >
> >
> > is there system stored procedure which returns all databases' owner
> > information?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >> Stay informed about: question about database ownership |
|
| Back to top |
|
| |
External
Since: Aug 10, 2004
Posts: 12
|
(Msg. 4) Posted: Thu Jun 23, 2005 3:15 pm
Post subject: Re: question about database ownership [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I am just more confused than ever...
one of three windows authentication accounts is actually existed on network.
I checked the account, it's valid.
so why sp_validatelogins return it as invalid?
"Britney" wrote in message
> Hi Tibor,
>
> I see 3 window authentication accounts list as orphan windows login after
I
> run sp_validatelogins.
> since it means those accounts don't exist in the Domain anymore, can I
> drop all those logins from all the databases?
> I shouldn't break anything, correct? Just want to make sure nothing
break
> if I drop those orphan windows login.
>
>
>
>
>
>
>
in
> > SQL Server and the database is fine with broken owner. But you don't
want
> to leave at that.
> >
> > Sp_validatelogin will list orphan Windows logins. You can use this, or
> code within and correlate
> > with sysdatabases (SID column) to list databases with orphaned Windows
> owners.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
<font color=green> > > <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=green> > > <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=green> > > Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
> >
> >
> > > Hi everyone,
> > > I have question about database ownership. We have a database
> called
> > > "price"
> > > "price" db was created by someone (John Doe) before, who is no longer
> > > working for our company.
> > >
> > > So in enterprise manager, I right-clicked on database "price" and go
to
> > > property page, I see owner as "DOMAIN\John.Doe"
> > > but I think DOMAIN\John.Doe is not valid user anymore in our domain,
> > > however, database is still working fine. I thought database would
break
> > > because the owner is no longer valid.... ??
> > >
> > > I know I can change ownership by using
> > >
> > > EXEC price..sp_changedbowner 'sa'
> > >
> > >
> > > is there system stored procedure which returns all databases' owner
> > > information?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
> >> Stay informed about: question about database ownership |
|
| Back to top |
|
| |
External
Since: Jan 29, 2004
Posts: 891
|
(Msg. 5) Posted: Thu Jun 23, 2005 4:55 pm
Post subject: Re: question about database ownership [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
It might have been removed from the domain and added back with the same name, but another SID.
--
Tibor Karaszi, SQL Server MVP
<a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.karaszi.com/sqlserver/default.asp</a>
<a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/" target="_blank">http://www.solidqualitylearning.com/</a>
Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/" target="_blank">http://solidqualitylearning.com/blogs/tibor/</a>
"Britney" wrote in message
>I am just more confused than ever...
> one of three windows authentication accounts is actually existed on network.
> I checked the account, it's valid.
>
> so why sp_validatelogins return it as invalid?
>
>
>> Hi Tibor,
>>
>> I see 3 window authentication accounts list as orphan windows login after
> I
>> run sp_validatelogins.
>> since it means those accounts don't exist in the Domain anymore, can I
>> drop all those logins from all the databases?
>> I shouldn't break anything, correct? Just want to make sure nothing
> break
>> if I drop those orphan windows login.
>>
>>
>>
>>
>>
>>
>>
> in
>> > SQL Server and the database is fine with broken owner. But you don't
> want
>> to leave at that.
>> >
>> > Sp_validatelogin will list orphan Windows logins. You can use this, or
>> code within and correlate
>> > with sysdatabases (SID column) to list databases with orphaned Windows
>> owners.
>> >
>> > --
>> > Tibor Karaszi, SQL Server MVP
<font color=brown> >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=brown> >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=brown> >> > Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
>> >
>> >
>> > > Hi everyone,
>> > > I have question about database ownership. We have a database
>> called
>> > > "price"
>> > > "price" db was created by someone (John Doe) before, who is no longer
>> > > working for our company.
>> > >
>> > > So in enterprise manager, I right-clicked on database "price" and go
> to
>> > > property page, I see owner as "DOMAIN\John.Doe"
>> > > but I think DOMAIN\John.Doe is not valid user anymore in our domain,
>> > > however, database is still working fine. I thought database would
> break
>> > > because the owner is no longer valid.... ??
>> > >
>> > > I know I can change ownership by using
>> > >
>> > > EXEC price..sp_changedbowner 'sa'
>> > >
>> > >
>> > > is there system stored procedure which returns all databases' owner
>> > > information?
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>>
>>
>
> >> Stay informed about: question about database ownership |
|
| Back to top |
|
| |
External
Since: Aug 10, 2004
Posts: 12
|
(Msg. 6) Posted: Thu Jun 23, 2005 5:22 pm
Post subject: Re: question about database ownership [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I see some jobs are running under orphan user's account..
I see them failed.. but I don't think it's orphan user's problem right?
sql job will still run under orphan user , correct?
Executed as user: DOMAIN\John.Doe. ...mpanyAttributes, 1) - Scan Density
currently 24% [SQLSTATE 01000] (Message 0) DBCC execution completed. If
DBCC printed error messages, contact your system administrator. [SQLSTATE
01000] (Message 2528) 23 Jun 2005 05:03:31:027 Executing DBCC INDEXDEFRAG
(0, CompanyAttributes, 2) - Scan Density currently 24% [SQLSTATE 01000]
(Message 0) DBCC execution completed. If DBCC printed error messages,
contact your system administrator. [SQLSTATE 01000] (Message 2528) 23 Jun
2005 05:03:32:353 Executing DBCC INDEXDEFRAG (0, CompanyAttributes, 3) -
Scan Density currently 23% [SQLSTATE 01000] (Message 0) DBCC execution
completed. If DBCC printed error messages, contact your system
administrator. [SQLSTATE 01000] (Message 2528) 23 Jun 2005 05:03:33:573
Executing DBCC INDEXDEFRAG (0, CompanyXref_trans, 2) - Scan Density
currently 40% [SQLSTATE 01000] (Message 0) DBCC execution completed. If
DBCC printed error messages, contact your system administrator.... The step
failed.
"Tibor Karaszi" wrote in
message
> It might have been removed from the domain and added back with the same
name, but another SID.
>
> --
> Tibor Karaszi, SQL Server MVP
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=purple> > Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
>
>
> >I am just more confused than ever...
> > one of three windows authentication accounts is actually existed on
network.
> > I checked the account, it's valid.
> >
> > so why sp_validatelogins return it as invalid?
> >
> >
> >> Hi Tibor,
> >>
> >> I see 3 window authentication accounts list as orphan windows login
after
> > I
> >> run sp_validatelogins.
> >> since it means those accounts don't exist in the Domain anymore, can
I
> >> drop all those logins from all the databases?
> >> I shouldn't break anything, correct? Just want to make sure nothing
> > break
> >> if I drop those orphan windows login.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
wrote
> > in
> >> > SQL Server and the database is fine with broken owner. But you don't
> > want
> >> to leave at that.
> >> >
> >> > Sp_validatelogin will list orphan Windows logins. You can use this,
or
> >> code within and correlate
> >> > with sysdatabases (SID column) to list databases with orphaned
Windows
> >> owners.
> >> >
> >> > --
> >> > Tibor Karaszi, SQL Server MVP
<font color=brown> > >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=brown> > >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=brown> > >> > Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
> >> >
> >> >
> >> > > Hi everyone,
> >> > > I have question about database ownership. We have a database
> >> called
> >> > > "price"
> >> > > "price" db was created by someone (John Doe) before, who is no
longer
> >> > > working for our company.
> >> > >
> >> > > So in enterprise manager, I right-clicked on database "price" and
go
> > to
> >> > > property page, I see owner as "DOMAIN\John.Doe"
> >> > > but I think DOMAIN\John.Doe is not valid user anymore in our
domain,
> >> > > however, database is still working fine. I thought database would
> > break
> >> > > because the owner is no longer valid.... ??
> >> > >
> >> > > I know I can change ownership by using
> >> > >
> >> > > EXEC price..sp_changedbowner 'sa'
> >> > >
> >> > >
> >> > > is there system stored procedure which returns all databases' owner
> >> > > information?
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> >
> >>
> >>
> >
> >
> >> Stay informed about: question about database ownership |
|
| Back to top |
|
| |
External
Since: Jan 29, 2004
Posts: 891
|
(Msg. 7) Posted: Thu Jun 23, 2005 6:55 pm
Post subject: Re: question about database ownership [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I don't see any error messages in there. If that is all you have, the jobstep shouldn't fail. If you
believe the owner is the problem, just set the job owner to sa.
--
Tibor Karaszi, SQL Server MVP
<a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.karaszi.com/sqlserver/default.asp</a>
<a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/" target="_blank">http://www.solidqualitylearning.com/</a>
Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/" target="_blank">http://solidqualitylearning.com/blogs/tibor/</a>
"Britney" wrote in message
>I see some jobs are running under orphan user's account..
> I see them failed.. but I don't think it's orphan user's problem right?
> sql job will still run under orphan user , correct?
>
>
> Executed as user: DOMAIN\John.Doe. ...mpanyAttributes, 1) - Scan Density
> currently 24% [SQLSTATE 01000] (Message 0) DBCC execution completed. If
> DBCC printed error messages, contact your system administrator. [SQLSTATE
> 01000] (Message 2528) 23 Jun 2005 05:03:31:027 Executing DBCC INDEXDEFRAG
> (0, CompanyAttributes, 2) - Scan Density currently 24% [SQLSTATE 01000]
> (Message 0) DBCC execution completed. If DBCC printed error messages,
> contact your system administrator. [SQLSTATE 01000] (Message 2528) 23 Jun
> 2005 05:03:32:353 Executing DBCC INDEXDEFRAG (0, CompanyAttributes, 3) -
> Scan Density currently 23% [SQLSTATE 01000] (Message 0) DBCC execution
> completed. If DBCC printed error messages, contact your system
> administrator. [SQLSTATE 01000] (Message 2528) 23 Jun 2005 05:03:33:573
> Executing DBCC INDEXDEFRAG (0, CompanyXref_trans, 2) - Scan Density
> currently 40% [SQLSTATE 01000] (Message 0) DBCC execution completed. If
> DBCC printed error messages, contact your system administrator.... The step
> failed.
>
>
>
>> It might have been removed from the domain and added back with the same
> name, but another SID.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
<font color=green> >> <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=green> >> <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=green> >> Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
>>
>>
>> >I am just more confused than ever...
>> > one of three windows authentication accounts is actually existed on
> network.
>> > I checked the account, it's valid.
>> >
>> > so why sp_validatelogins return it as invalid?
>> >
>> >
>> >> Hi Tibor,
>> >>
>> >> I see 3 window authentication accounts list as orphan windows login
> after
>> > I
>> >> run sp_validatelogins.
>> >> since it means those accounts don't exist in the Domain anymore, can
> I
>> >> drop all those logins from all the databases?
>> >> I shouldn't break anything, correct? Just want to make sure nothing
>> > break
>> >> if I drop those orphan windows login.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
> wrote
>> > in
>> >> > SQL Server and the database is fine with broken owner. But you don't
>> > want
>> >> to leave at that.
>> >> >
>> >> > Sp_validatelogin will list orphan Windows logins. You can use this,
> or
>> >> code within and correlate
>> >> > with sysdatabases (SID column) to list databases with orphaned
> Windows
>> >> owners.
>> >> >
>> >> > --
>> >> > Tibor Karaszi, SQL Server MVP
<font color=brown> >> >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp</font" target="_blank">http://www.karaszi.com/sqlserver/default.asp</font</a>>
<font color=brown> >> >> > <a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/</font" target="_blank">http://www.solidqualitylearning.com/</font</a>>
<font color=brown> >> >> > Blog: <a rel="nofollow" style='text-decoration: none;' href="http://solidqualitylearning.com/blogs/tibor/</font" target="_blank">http://solidqualitylearning.com/blogs/tibor/</font</a>>
>> >> >
>> >> >
>> >> > > Hi everyone,
>> >> > > I have question about database ownership. We have a database
>> >> called
>> >> > > "price"
>> >> > > "price" db was created by someone (John Doe) before, who is no
> longer
>> >> > > working for our company.
>> >> > >
>> >> > > So in enterprise manager, I right-clicked on database "price" and
> go
>> > to
>> >> > > property page, I see owner as "DOMAIN\John.Doe"
>> >> > > but I think DOMAIN\John.Doe is not valid user anymore in our
> domain,
>> >> > > however, database is still working fine. I thought database would
>> > break
>> >> > > because the owner is no longer valid.... ??
>> >> > >
>> >> > > I know I can change ownership by using
>> >> > >
>> >> > > EXEC price..sp_changedbowner 'sa'
>> >> > >
>> >> > >
>> >> > > is there system stored procedure which returns all databases' owner
>> >> > > information?
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>
> >> Stay informed about: question about database ownership |
|
| Back to top |
|
| |
| Related Topics: | Changing table ownership - Hello, I need to change table ownership - but am being told schemas have to be changed in SQL 2005. Now seeing an error: Invalid object name 'dbo.address1'. Currently that table is called 'admin.address1' So I thought changing the ownership would do....
Database Mail Question - Hello everyone, I am wondering if Database Mail on SQL server 2005 has the ability to delay the sending of an email message. For instance I would like to allow reminders to be sent from Sql server according to a column that specifies a DateTime in the..
Question on database design - We've been asked to take over support and maintenance of a new client's web-based application (ASP.NET sitting on SQL Server 2005) It's basically an accommodation booking system, and at first sight it's extremely well-made. I've been asked to take a..
Legacy Database Question - I've been asked to look into converting a set of legacy code/legacy database from Access to SQL Server. The legacy code has considerable VB code which connects to MATLAB and Excel. Anyone have any ideas on a "simple" way to move to SQL Serv...
Database Mail Question - Hello, I'm sending an email using sp_send_dbmail in HTML format. The email works great but within the HTML is a link to an image that I can't get to show in the email. I just get the empy object. It works fine when I have everything configured on.... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
