You are not logged on as the db owner or sysadmin

Question

Post reply

You are not logged on as the db owner or sysadmin

Tara-1044200

SSCoach

Points: 15951
More actions
April 14, 2009 at 10:08 am

#203583

Though a user a has ddl_admin rights on databases but still gets this error when editing a table from design mode.

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

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

Tara-1044200 SSCoach Points: 15951 More actions · Answer 1

also gave view definition access to the database but still gives the error.

Jeffrey Williams SSC Guru Points: 90313 More actions · Answer 2

I believe the GUI tools require a higher privilege than just ddl_admin. Basically, this privilege allows the user to issue the DDL statements, but does not allow usage of the GUI tools.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs