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?
LVL 1
MilewskpAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor 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
 
rockiroadsConnect With a Mentor Commented:
I thought dbSecWriteDef  referred to modifying and deleting table defintions

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

0
 
MilewskpAuthor Commented:
Thanks guys.
0
All Courses

From novice to tech pro — start learning today.