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). You can change the name and password of the DBA user using the DBA USER and DBA PASSWORD clauses of the CREATE DATABASE statement or by specifying the dbinit -dba option. See CREATE DATABASE statement, and Initialization utility (dbinit).
The DBA user ID automatically has DBA authority within the database. This level of permission enables DBA users to perform any activity in the database. They can create tables, change table structures, create new user IDs, revoke permissions from users, back up the database, and so on.
DBA authority is not inherited by group membership.
You only have DBA authority on a database if you are connected to it.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |