June 27, 2018 at 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.
June 27, 2018 at 1:14 pm
Tara-1044200 - Wednesday, June 27, 2018 12:56 PMdo 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)
June 27, 2018 at 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"
June 27, 2018 at 2:47 pm
Tara-1044200 - Wednesday, June 27, 2018 1:52 PMi 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
June 28, 2018 at 7:58 am
it allows me to add a column but it does not allow to change a data type using SSMS.
June 28, 2018 at 8:17 am
Tara-1044200 - Thursday, June 28, 2018 7:58 AMit 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
June 28, 2018 at 8:22 am
Sue_H - Thursday, June 28, 2018 8:17 AMTara-1044200 - Thursday, June 28, 2018 7:58 AMit 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)
June 28, 2018 at 8:32 am
Sue_H - Thursday, June 28, 2018 8:17 AMTara-1044200 - Thursday, June 28, 2018 7:58 AMit 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.
June 28, 2018 at 10:12 am
Lynn Pettis - Thursday, June 28, 2018 8:32 AMSue_H - Thursday, June 28, 2018 8:17 AMTara-1044200 - Thursday, June 28, 2018 7:58 AMit 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
June 28, 2018 at 10:50 am
Sue_H - Thursday, June 28, 2018 10:12 AMLynn Pettis - Thursday, June 28, 2018 8:32 AMSue_H - Thursday, June 28, 2018 8:17 AMTara-1044200 - Thursday, June 28, 2018 7:58 AMit 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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply