954,593 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

How to grant the permissions for the users to alter the tables definition ?

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..

jacksantho
Junior Poster
164 posts since Feb 2011
Reputation Points: 7
Solved Threads: 0
 

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

arden_k
Newbie Poster
16 posts since Jan 2012
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You