Alter table permissions

Question

Alter table permissions

rasoulov

Right there with Babe

Points: 765
More actions
April 18, 2006 at 10:06 am

#89921

Hi,
I hope someone can help. I can't find anything when I search google. Here's the problem. I have a development server sql 2005 standard edition. I have given developers ddladmin on a particular db. They are not able to modify tables through the gui but they can when they right alter table scripts. Anyone experiencing this problem. Any solutions???

Thanks,
Alina

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

It might be that they are connecting via enterprise manager with their Windows credentials, but connecting via Query Analyzer with a SQL login;

in that situation the SQL login might have the ddladmin rights, but the NT login does not.

In Enterprise Manager,have your developer right click on the server and select "Edit SQL Server Registration properties", and review which option button is checked..."Windows authentication" or "Use SQL Server authentication"

The GUI saves that inormation for connection purposes, i bet that is where the security issue lies.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

rasoulov Right there with Babe Points: 765 More actions · Answer 2

This happens in 2005 and they are loggin in with the same credentials. I tried creating a sql account and connecting to management studio with it and then opening a query window with the same account. I am able to alter the table in a query window but not through the management studio window.

Richard Murphy Valued Member Points: 68 More actions · Answer 3

I am having the same problem. This must be a bug with the GUI. Users with ddladmin can modify DDL with alter table scripts but not through Management Studio. Very strange!!