alter a table using GUI without having db_owner access

  • Hi All,

    Is it possible for a user to alter a table using GUI without having db_owner access to that database?

  • Is it possible for a user to alter a table using GUI without having db_owner access to that database?

    I believe so, but, you will have to have the appropriate privileges to make any changes.

    For instance, you should be able to change tables you own.

  • The user would need to have either ownership of the schema or control/alter permissions on the table. The means of connection to the server is irrelevant.

Viewing 3 posts - 1 through 2 (of 2 total)

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