Member Avatar for jacksantho

Hi,

For the users, i grant the permissions to create a table and then i also given the
permission to alter table i.e

grant alter on san to user;

Logging as user:
Table (design mode), am getting the error:
"You are not logged on as the database owner or system administrator. you might not be
able to save the changes to tables that you do not own."

second error:
table dbo.[..] is set to read only, user doesn't have enough rights on this table.

Can anybody help me out to solve this thread. Needed TSQL..

  • 2 Contributors
  • 1 Reply
  • 133 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by arden_k
Member Avatar for arden_k

Did you try to alter the users role so they are an admin or owner of that database?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.