Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » User IDs, authorities, and permissions » Authorities


DBA authority

When you create a database, a single usable user ID is also created. By default, the first user ID is DBA, and the password is initially sql (passwords are case sensitive).

The DBA user ID automatically has DBA authority within the database. DBA authority allows users to perform any activity in the database. Users with DBA authority can create database objects and assign ownership of these objects to other user IDs, change table structures, create new user IDs, revoke permissions from users, back up the database, and so on.

A user with DBA authority becomes a database administrator. References made to the database administrator, or DBA, include all users with DBA authority.

DBA authority may be granted or transferred to other user IDs. DBA authority is not inherited by group membership.


To prevent unauthorized access to your data, you should change the password for the initial user with DBA authority (or change the user name and password) before deploying the database by using the DBA USER and DBA PASSWORD clauses of the CREATE DATABASE statement or the dbinit -dba option. See Passwords.

 See also

DBA authentication