April 15, 2004 at 12:53 pm
What is the minimum set of rights to give an account so that when it creates a table, the table is owned by dbo? Unfortunately, making the account dbo in the database isn't enough unless dbo is explicitly part of the create table command.
Our trouble-ticket software administration utility creates tables and they end up being owned by the account that created them. I have to then run a script to change the schema. Short of making the account a member of the system admin role, is there anything else I can do?
Thanks,
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 15, 2004 at 1:00 pm
We actually aliased the admin account as the dbo user in the database.
April 15, 2004 at 1:10 pm
Thanks! That worked!
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 15, 2004 at 2:48 pm
The fixed database role db_ddladmin also has rights to create an object under the ownership of any user, to include dbo.
K. Brian Kelley
@kbriankelley
April 16, 2004 at 4:53 am
The problem with most 3rd party trouble ticket software is that it doesn't give you the option to do that and will create the objects as owned by the user account that is logging into the database.
April 16, 2004 at 7:03 am
True. Unless the owner is specified, it will be as the user who created them, meaning aliasing is pretty much it.
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply