December 12, 2016 at 2:57 pm
Hello experts,
I added a login to the db_ddladmin fixed database role, which according to the MS documentation has CREATE TABLE permissions.
But when he tries to create a table, he gets this error:
"You are not logged on as the database owner or system administrator. You might not be able to save changes to tables that you do not own."
Does anyone know why he would get this error? I could try adding him to db_owner or issuing a GRANT CREATE TABLE, but I don't want to do so until I understand why adding him to db_ddladmin is not working.
Thanks for any help!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 12, 2016 at 3:28 pm
It's just a warning, and shouldn't prevent the login in question from actually creating the table.
Further, as far as I've seen it's just a quirk of SSMS when designing through the GUI, so having them learn a bit of TSQL should function nicely as a workaround 🙂
This oddity has been known for a while, and MS supposedly fixed it a while ago (https://connect.microsoft.com/SQLServer/feedback/details/467582/db-ddladmin-role-doesnt-allow-use-of-design-functions-in-ssms), but it's persisted in every SSMS/Database Engine version combination I've tested it on.
Cheers!
December 13, 2016 at 8:20 am
Jacob Wilkins (12/12/2016)
It's just a warning, and shouldn't prevent the login in question from actually creating the table.Further, as far as I've seen it's just a quirk of SSMS when designing through the GUI, so having them learn a bit of TSQL should function nicely as a workaround 🙂
This oddity has been known for a while, and MS supposedly fixed it a while ago (https://connect.microsoft.com/SQLServer/feedback/details/467582/db-ddladmin-role-doesnt-allow-use-of-design-functions-in-ssms), but it's persisted in every SSMS/Database Engine version combination I've tested it on.
Cheers!
Thanks, Jacob! It does look like a quirk, so I followed your advice and asked them to try T-SQL. 🙂
Thanks again!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply