Table <Tablename> is set to read only, user doesn't have enough rights on this table.
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

Table <Tablename> is set to read only, user doesn't have enough rights on this table.

You are logged into the database as a user that does not have the appropriate rights to view the table definition. For example, if you have only SELECT rights to a table and try to view the table definition, then this message appears.

  1. You need the following permissions in order to access the table:

    1. ALTER TABLE
    2. VIEW DEFINITION
  2. Other permission-related errors may have prevented the table definition from loading in read-write mode. Check for and resolve those errors by contacting the server administrator.

Show:
© 2016 Microsoft