Post reply

ddl_admin role

  • December 22, 2016 at 3:49 pm

    #332921

    I am unable to alter a database table with ddl admin permission. I get the following 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."

    I do not want to grant the user performing this task db_owner. Is there a work around this?

    Any help will be appreciated.

    Thanks.

  • December 22, 2016 at 4:04 pm

    #1919446

    Is the individually attempting to make changes to a table that has data or to empty tables?

  • December 22, 2016 at 4:06 pm

    #1919449

    The table contains data...

  • December 22, 2016 at 4:13 pm

    #1919450

    smatu (12/22/2016)

    The table contains data...

    That could be the issue. Plus, looking up the db_ddladmin role, it doesn't appear to have alter permissions to tables, procedures, functions, and a few others.

    Just guessing here, but it looks as though db_ddladmin may not have the permissions needed to alter actively used tables in this case. You maybe be able to assign the necessary permissions to the user but I couldn't tell you what is needed off the top of my head.

  • December 22, 2016 at 4:26 pm

    #1919453

    Is there a fixed db role that allows a user to alter a table other than db_owner?

  • December 23, 2016 at 3:14 am

    #1919481

    Where are you getting that error from? It doesn't look like a SQL server error message.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 23, 2016 at 3:17 am

    #1919482

    It sounds Access-y.

  • December 23, 2016 at 10:00 am

    #1919534

    smatu (12/22/2016)

    I am unable to alter a database table with ddl admin permission. I get the following 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."

    I do not want to grant the user performing this task db_owner. Is there a work around this?

    Any help will be appreciated.

    Thanks.

    That error message can come from the Diagram tool. If that's where you are getting the message, you may want to look at this article as I think it likely applies to 2008 as well:

    https://blogs.msdn.microsoft.com/mangeshd/2008/02/08/non-dbo-users-may-not-be-able-to-create-dabase-diagrams-in-sql-server-2005/

    Sue

Viewing 8 posts - 1 through 7 (of 7 total)

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