Required Authorities/Groups for Administration

Menu items are disabled unless you have the correct authority, or group membership, for a particular administration task.

Administration Category Administration Task Required Authorities/Groups
Monitoring Monitor DBA authority or SCC_MONITOR group
Multiplex administration Add secondary node DBA authority (or Multiplex Admin and Backup and Space Admin authority)
  Drop secondary node DBA authority
  Include a secondary node DBA authority (or Multiplex Admin and Backup authority)
  Exclude a secondary node DBA or Multiplex Admin authority
  Synchronize a secondary node DBA authority
  Configure server DBA or Multiplex Admin authority
  Change reader to writer, or writer to reader DBA or Multiplex Admin authority
  Change designated failover node DBA or Multiplex Admin authority
  Manual failover DBA or Multiplex Admin authority
  Change multiplex name DBA or Multiplex Admin authority
  Modify multiplex property sheet DBA or Multiplex Admin authority
Simplex and multiplex server administration Start server n/a
  Stop server DBA authority
  Multiplex server property sheet IQ server is authenticated
Logical server administration Create logical server DBA or Multiplex Admin authority
  Delete logical server DBA or Multiplex Admin authority
  Configure logical server DBA or Multiplex Admin authority
  Edit logical server policy DBA or Multiplex Admin authority
  Modify logical server property sheet DBA or Multiplex Admin authority
Database administration Create database Utility DB user and password must be passed from the user to the Sybase Control Center agent.
  Edit database option DBA authority
  Edit license management DBA authority
  Modify database property sheet DBA authority
Dbspace administration Create dbspace DBA or Space Admin authority
  Delete dbspace DBA or Space Admin authority
  Pre-allocate catalog dbspace DBA or Space Admin authority
  Change dbspace name, mode, status, striping, stripe size DBA or Space Admin authority
  Create db file DBA or Space Admin authority
  Delete db file DBA or Space Admin authority
  Empty file DBA or Space Admin authority
  Change file name, path, mode, size DBA or Space Admin authority
  Modify dbspace property sheet DBA or Space Admin authority
Security administration Create user/group DBA (or User Admin & Perms Admin) authority
  Delete user/group DBA or User Admin authority
  Change user to group DBA or Perms Admin authority
  Change group to user DBA or Perms Admin authority
  Edit user/group options DBA authority
  Edit user/group properties DBA (or User Admin & Perms Admin) authority
  Edit user/group authorities DBA or Perms Admin authority
  Manage parent groups DBA or Perms Admin authority
  Manage group members DBA or Perms Admin authority
  Create login policy DBA or User Admin authority
  Delete login policy DBA or User Admin authority
  Edit login policy options and comment DBA or User Admin authority
  Modify user/group property sheet DBA (or User Admin & Perms Admin) authority
  Modify login policy property sheet DBA or User Admin authority