Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

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

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?
0
Milewskp
Asked:
Milewskp
2 Solutions
 
rockiroadsCommented:
I thought dbSecWriteDef  referred to modifying and deleting table defintions

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

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.

0
 
MilewskpAuthor Commented:
Thanks guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now