Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont.
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 12/14/04
- Next message: FTL: "Install - datadir and targetdir (again)"
- Previous message: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- In reply to: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- Next in thread: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- Reply: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 12:01:28 +0100
hi Andrew,
"CodeMonkey" <agaskelluk@yahoo.com> ha scritto nel messaggio
news:1103021537.911855.37930@c13g2000cwb.googlegroups.com
> Andrea
> thanks for the response.
>
>> perhaps your somedomain\testuser is member of dbowner database rose
>> and/or part of the sysadmins server role...
>
> No, he's not a member of either.
> However on the server, If I select the server role sysadmin, I see
> that BUILTIN\Administrators is a member. somedomain\testuser has admin
> rights on his local PC, so is this why he becomes the owner of the
> MSDE database when it is installed locally?
if somedomain\testuser is member of BUILTIN\Administrators the he/she is for
sure member of sysadmins (local) server role..
he/she will not become owner of the attached database, as the owner will
remain the original one, but he/she will be able to create new databases as
long as attach detached ones...
usually it's not a good idea to log on as (local) admin on client pc
workstations too :D
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: FTL: "Install - datadir and targetdir (again)"
- Previous message: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- In reply to: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- Next in thread: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- Reply: CodeMonkey: "Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
