Cannot add column in Management Studio

Question

Post reply

Cannot add column in Management Studio

balbirsinghsodhi

SSCrazy Eights

Points: 9210
More actions
November 10, 2008 at 12:38 pm

#195927

One of my user cannot add column in the table using Management studio but he can do by using Alter command on Query Analyzer.
User has a dbo permission on the database.
What more permission do user need to add column in the table by using management studio.
appreciated if someone can help.

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

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

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 1

What error does the user get when he tries adding a column from the Management Studio??

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 2

thanks for your quick response.

Access Denied. But when he uses Alter command on query analyzer, he is not getting that error.

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 3

make him the ddlAdmin. And revoke the permission once he adds the column to it.

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 4

I gave ddlAdmin access but no help.

User is in the AD group and also have an individual account. do you know which gets the preference. ?

Kyle Neier , SSCrazy Points: 2252 More actions · Answer 5

Since the user has dbo permissions, making him ddl_admin would likely not help anything.

When using Mgmt Studio, make certain that the instance is the same as Query Analyzer. You should also verify that the login credentials are the same. I've seen some cases where the the user had registered the instance under different credentials and that was cached from that point forward.

In Mgmt Studio, if you click the "New Query" button while within the SQL instance context, does the alter statement work?

Kyle

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 6

I have checked the instance of the Mgmt studio and query analyzer, it's same.

It's really weird. I think users have access but some how management studio is not recognizing it.

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 7

AD and SQl get preferences alike if its a Mixed mode authentication. To be certain that it is not a permission issue I would suggest to use the SQL login on which the user is either a dbo or ddladmin and the access the management studio to create the column.

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 8

It's working if I create a SQL login and give dba access.