dbo issues
From: Paul Fell (penzina_at_iinet.net.au)
Date: 08/29/03
- Next message: Tino Uhlig: "SSL encryption"
- Previous message: Sue Hoegemeier: "Re: Database encryption software"
- Next in thread: Russell Fields: "Re: dbo issues"
- Reply: Russell Fields: "Re: dbo issues"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: 28 Aug 2003 19:40:18 -0700
SQL Server 2000
Win 2000 Server
Our security in SQL Server is governed by User Groups in Wind2K. For
example we have a user group called ClientsMaxcor with several of our
users included in this Windows Group Account. This account uses
Windows authentication to log on to the SQL Server and the database in
which they have responsibility. We have setup dbo (and public) for
this account for this database.
The problem is that when the users create an object it gets prefixed
with their group account name login instead of dbo. How can I set this
account so that dbo is always used as owner of the object(s). The
Group account as not been given any server based roles.
Any help much appreciated.
Paul
- Next message: Tino Uhlig: "SSL encryption"
- Previous message: Sue Hoegemeier: "Re: Database encryption software"
- Next in thread: Russell Fields: "Re: dbo issues"
- Reply: Russell Fields: "Re: dbo issues"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
