Hi,
I have a developer here, that when she logs into and creates tables in the database, the owner of the table is her login, not dbo.
How can I change the settings so that the tables she creates belongs to dbo instead?
Or alternatively, she needs to be able to run:
execute sp_changeobjectowner 'HerLogin', 'dbo'
Is there a way to grant execute permission on a single system stored procedure to a single user?
Thanks!!
I have a developer here, that when she logs into and creates tables in the database, the owner of the table is her login, not dbo.
How can I change the settings so that the tables she creates belongs to dbo instead?
Or alternatively, she needs to be able to run:
execute sp_changeobjectowner 'HerLogin', 'dbo'
Is there a way to grant execute permission on a single system stored procedure to a single user?
Thanks!!