We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

What permissions are required to change Startup options and other database properties?

Milewskp
Milewskp asked
on
Medium Priority
397 Views
Last Modified: 2008-02-01
In order to change the Startup options of a database, do you need dbSecWriteDef permission, or is it sufficient to have dbSecDBAdmin permission?
In order to create/ change other database properties (including custom properties), do you need dbSecWriteDef permission, dbSecDBAdmin permission, or both?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006
Commented:
I thought dbSecWriteDef  referred to modifying and deleting table defintions

u may need dbSecDBAdmin to do this. failing that there is always dbSecFullAccess

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
dbSecDBAdmin does provide you the ability to change settings in the Startup dialog (or through VBA); I'd assume that it also allows changes to user defined as well. From what I've been able to garner in the past, the only thing "higher' than dbSecDBAdim would be dbSecFullAccess, as rocki suggests.

Author

Commented:
Thanks guys.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.