Document TypeㅣTechnical Information
CategoryㅣAdministration
Applicable Product Versionㅣ6FS07PS, 7FS02PS
Document NumberㅣTADTI012
Overview
This is information on Tibero database Default Users including the Default Users added with version upgrades.
The default user accounts created when installing or upgrading the Tibero database each have unique roles and privileges.
Method
The Default accounts in Tibero DB are as follows.
Schema | Description |
|---|---|
SYS | Account for database management that creates and manages system packages, synonyms, users, roles, virtual tables, sequences, dynamic views, etc. |
SYSCAT | Account that creates and manages static catalog views for database management |
SYSGIS | Account that creates and manages tables related to GIS (Geographic Information System) |
OUTLN | Account that stores related hints so that the same SQL always executes with the same query plan |
TIBERO, TIBERO1 | Sample user accounts granted CONNECT, RESOURCE, DBA roles |
SYSBACKUP | - An account with all privileges related to backup/recovery but not SYS account - Can log in in NOMOUNT, MOUNT modes |
LBACSYS | Label Security System User that manages policies, audits, users, tables related to Label Security |
NoteOpening the DB with alter database open is only possible from the SYS account. (Not possible with SYSBACKUP account)If attempted, TBR-7607 (cannot open database) error will occur.