db_owner

Question

db_owner

Tara-1044200

SSCoach

Points: 15951
More actions
June 27, 2018 at 12:56 pm

#370319

do i need to be database owner to change table definition from SSMS? I am not able to do that with ddl_admin permissions from SSMS but i can using t-sql.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

Tara-1044200 - Wednesday, June 27, 2018 12:56 PM
do i need to be database owner to change table definition from SSMS? I am not able to do that with ddl_admin permissions from SSMS but i can using t-sql.

What happens when you try to do it within SSMS? Is an error generated? If so, please post the specifics. It may not be a permissions problem, but the only way to know is to find out what, exactly, the problem was...

Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy)

Tara-1044200 SSCoach Points: 15951 More actions · Answer 2

i get this when i go to design mode to change anything

" you are not logged in as database owner , you might not be able to save changes to the tables that you do not own"

Sue_H SSC Guru Points: 90860 More actions · Answer 3

Tara-1044200 - Wednesday, June 27, 2018 1:52 PM
i get this when i go to design mode to change anything
" you are not logged in as database owner , you might not be able to save changes to the tables that you do not own"

Make the changes and save them anyway. I think you get one other warning when you save as well. If you are ddl_admin, the changes will stick.

Sue

Tara-1044200 SSCoach Points: 15951 More actions · Answer 4

it allows me to add a column but it does not allow to change a data type using SSMS.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

Tara-1044200 - Thursday, June 28, 2018 7:58 AM
it allows me to add a column but it does not allow to change a data type using SSMS.

It would really help if you could post the message you get.
If you are getting a message that says something like "changes require the tables to be dropped and recreated", anyone would get that error as it's a change that isn't allowed using the GUI. It has nothing to do with permissions.

Sue

sgmunson SSC Guru Points: 110640 More actions · Answer 6

Sue_H - Thursday, June 28, 2018 8:17 AM
Tara-1044200 - Thursday, June 28, 2018 7:58 AM
it allows me to add a column but it does not allow to change a data type using SSMS.
It would really help if you could post the message you get.
If you are getting a message that says something like "changes require the tables to be dropped and recreated", anyone would get that error as it's a change that isn't allowed using the GUI. It has nothing to do with permissions.
Sue

+1,000 to that. This was why I had previously asked for the original poster to specify the error message.

Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Sue_H - Thursday, June 28, 2018 8:17 AM
Tara-1044200 - Thursday, June 28, 2018 7:58 AM
it allows me to add a column but it does not allow to change a data type using SSMS.
It would really help if you could post the message you get.
If you are getting a message that says something like "changes require the tables to be dropped and recreated", anyone would get that error as it's a change that isn't allowed using the GUI. It has nothing to do with permissions.
Sue

That would be a configuration change in SSMS if I remember correctly.

Sue_H SSC Guru Points: 90860 More actions · Answer 8

Lynn Pettis - Thursday, June 28, 2018 8:32 AM
Sue_H - Thursday, June 28, 2018 8:17 AM
Tara-1044200 - Thursday, June 28, 2018 7:58 AM
it allows me to add a column but it does not allow to change a data type using SSMS.
It would really help if you could post the message you get.
If you are getting a message that says something like "changes require the tables to be dropped and recreated", anyone would get that error as it's a change that isn't allowed using the GUI. It has nothing to do with permissions.
Sue
That would be a configuration change in SSMS if I remember correctly.

Tools, Options Designer - disable "Prevent saving changes that require the table re-creation"
But the error message is unknown. Either way, it's not a permissions issue and not related to whether a user is db_owner or not.

Sue

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Sue_H - Thursday, June 28, 2018 10:12 AM
Lynn Pettis - Thursday, June 28, 2018 8:32 AM
Sue_H - Thursday, June 28, 2018 8:17 AM
Tara-1044200 - Thursday, June 28, 2018 7:58 AM
it allows me to add a column but it does not allow to change a data type using SSMS.
It would really help if you could post the message you get.
If you are getting a message that says something like "changes require the tables to be dropped and recreated", anyone would get that error as it's a change that isn't allowed using the GUI. It has nothing to do with permissions.
Sue
That would be a configuration change in SSMS if I remember correctly.
Tools, Options Designer - disable "Prevent saving changes that require the table re-creation"
But the error message is unknown. Either way, it's not a permissions issue and not related to whether a user is db_owner or not.
Sue

That is why we need to know the error message the OP is receiving.

db_owner

Cookies on SQLServerCentral