Re: dbo role and modify filesize of database
From: Mickey Red (mred_at_red.com)
Date: 02/28/04
- Next message: Mac Davis: "Login failed for user 'IIS'. Reason: Not associated with a trusted SQL Server connection."
- Previous message: kyeker: "sql backup"
- In reply to: Dan Guzman: "Re: dbo role and modify filesize of database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 28 Feb 2004 09:01:05 -0600
Hi Dan
Thanks for your reply. I will either try one of the two techniques
you mentioned. Probably it would be the second. Because I don't do
not trust to much the developers.
Kind regards
Mickey
"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in
news:OYpmz0T$DHA.3712@tk2msftngp13.phx.gbl:
> If your developers need permission to create objects owned by other
> users, you can add them to the db_ddladmin and db_securityadmin fixed
> database roles. Like db_owner, they can create dbo-owned objects and
> grant permissions on them but will not be able to alter the database.
> However, with db_securityadmin they could also add themselves to
> db_owner so it depends how much you trust your developers.
>
> Another technique is to just grant them CREATE permissions for the
> appropriate object types. Newly created objects will be initially
> owned by the developer's userid and you can later change the object
> owner to the one desired using sp_changeobjectowner.
>
- Next message: Mac Davis: "Login failed for user 'IIS'. Reason: Not associated with a trusted SQL Server connection."
- Previous message: kyeker: "sql backup"
- In reply to: Dan Guzman: "Re: dbo role and modify filesize of database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
