defaulting newly created objects to DBO
From: Rafet (rducic_at_hotmail.com)
Date: 03/05/04
- Next message: Kim Lyon: "VB Application connection to sensitive data"
- Previous message: Dan Guzman: "Re: MSDB access removed when approle (in a user db) is set?"
- Next in thread: Randy: "RE: defaulting newly created objects to DBO"
- Reply: Randy: "RE: defaulting newly created objects to DBO"
- Reply: Sue Hoegemeier: "Re: defaulting newly created objects to DBO"
- Reply: Jeff L.: "RE: defaulting newly created objects to DBO"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: 5 Mar 2004 07:16:48 -0800
Hi, i know that for non-sysadmin role members, non-qualified objects
will be owned by the creating user.
Is it possible to change this so that objects created by users
belonging to database role 'db_owner' default to dbo?
Thanks,
Rafet
- Next message: Kim Lyon: "VB Application connection to sensitive data"
- Previous message: Dan Guzman: "Re: MSDB access removed when approle (in a user db) is set?"
- Next in thread: Randy: "RE: defaulting newly created objects to DBO"
- Reply: Randy: "RE: defaulting newly created objects to DBO"
- Reply: Sue Hoegemeier: "Re: defaulting newly created objects to DBO"
- Reply: Jeff L.: "RE: defaulting newly created objects to DBO"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]