Re: Schema Sharing
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 06 Apr 2006 20:06:08 -0600
A schema can be owned by a role or a windows group. If you
have/create a role or a group that all the developers belong
to, you can have that role or group own the schema. To
change the owner, execute
alter authorization on schema::YourSchema to YourRoleOrGroup
-Sue
On Thu, 6 Apr 2006 18:38:01 -0700, RAJ
<RAJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hello all,
I have an database in SQL Server 2005 and this database is maintained (table
changes & procedures) by 2 groups of people. So, what I did is, created an
new schema and also created an generic sql server account and assigned the
schema I created earlier. It works fine.
I prefer not to use the generic account and want to allow the developers to
use their own domain account. Is it possible to assign many users to an
schema so that, any developer can create/update his objects, but all the
objects fall under one schema ?
I hope I made myself clear in my request.
Any suggestions for achieving this goal ? Is it possible ?
Thanks for your time.
RAJ
.
- Prev by Date: Re: help.. urgent..database master key..2005
- Next by Date: Re: SQL Server 2005 - getting Bruteforced
- Previous by thread: 2005 Endpoints Security....
- Next by thread: Re: Datalink error for integrated login. "Can not generate SSPI Conte
- Index(es):
Relevant Pages
|
