Home Forums SQL Server 2005 Administering Fixed server role required for Object creation in sys databases? RE: Fixed server role required for Object creation in sys databases?

  • I have no control over it. It is simply an operation that is executed with certain application activities. I'm not sure what the final result is.

    My question is whether with these "black-box" behind the scenes operations going on, does that account connecting to SQL Server need to be sysadmin to have privileges to do this?

    In essence, can a non-Sysadmin, non-DBO, or non-db_owner role member create objects in the system databases? I would assume not, but I'm unsure.

    Thanks.