Use the following procedure to create the principal database administrator, DBADMIN. For sites that require multiple database administrators, create lower level administrative users who log on as individuals. Do not allow multiple users to log on as DBADMIN, which prevents the system from logging the actions of individuals.
- Log on to the database as user DBC.
- Create the database administrator:
CREATE USER DBADMIN FROM DBC AS PERM = perm_space PASSWORD = "temporary_password" [ DEFAULT DATABASE = DBADMIN ] [ PROFILE = AdminProfile ];
- DBADMIN
- The name of the database administrator user. You can specify a different username, but all the examples refer to the database administrator as DBADMIN.
- DBC
- The owner of the space in which you create user DBADMIN.
- perm_space
- The space in bytes that contains all objects that user DBADMIN creates or owns. Because user DBADMIN creates and owns nearly all Vantagedatabases and tables, you should assign it the majority of space on the system.
- temporary_password
- The temporary password for DBADMIN.
- DEFAULT DATABASE = DBADMIN
- [Optional] The user or database that contains the space in which the SQL Engine stores or searches for new or target objects, unless the transaction SQL specifies a different database.
- PROFILE = AdminProfile
- [Optional] The name of the profile for DBADMIN.
Related Information
Information on... | Is available in... |
---|---|
Syntax and options for the CREATE USER statement | Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184. |
Guidelines for determining administrator space requirements and long term managing of space | Teradata Vantage™ - Database Administration, B035-1093. |
Default password control values and how to change them | Managing Database Passwords. |