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 |