The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Based on some discussions on the power of the DBA authority lately in this forum, I have the impression that there's a general rule for SQL Anywhere like the following (to cite Justin):

By definition DBA can do anything - they are the owner of the database.

So I would like to know what exactly DBA1 can do that DBA2 cannot undo or drop?

Some more discussion on this can be found in the newsgroups, e.g. in these threads:

I should add that this question is not dealing with topics like "Do users of my application need DBA authority to do backups or create other users?" - For these cases, it's a widely accepted best-practise to give particular users execute permission on according stored procedures (and the like) to allow these DBA actions, but to do not grant them DBA authority.

This question is more focussed on enterprise/in-house databases with more than one DBA account.

asked 12 Feb '12, 16:54

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

edited 12 Feb '12, 18:01

Well, there's Dogbert the patron saint of DBAs... he can perform miracles. alt text

(12 Feb '12, 16:59) Breck Carter
Replies hidden

Hmm, I hope the list below could be improved over time to count as "actual issues", Saint Breck?

(12 Feb '12, 17:16) Volker Barth

I'd like to attempt to make a list of the things DBA2 can or can not do - and I would invite anyone to add/comment on this - consider this just a starting point...

Basically, I will assume there are two users with DBA authority named DBA1 and DBA2, and would assume that DBA2 might turn into malicious intentions:

I. What DBA2 can do:

  • DBA2 can alter or drop any database object any other user (including DBA1) has created.
  • DBA2 can alter (grant/revoke) any permissions on any database object.
  • DBA2 can revoke DBA1's DBA authority - and vice versa.
  • DBA2 can drop DBA1's user account or change its password (or set it to an empty string to disallow any connection from DBA1) - and vice versa.
  • DBA2 can modify/drop any login procedure that would try to enforce particular login logic.
  • Encrypted tables/columns are just stored in encrypted form, but are decrypted when accessed - therefore any user with access to such data can read the "plaintext", including DBA2.

II. What DBA2 cannot do:

  • As anybody else, DBA2 cannot read the source of any object SET HIDDEN by DBA1 (and cannot set it UNHIDDEN, as there no such statement - but DBA2 can still ALTER the object).
  • Strong database encryption is beyond database authorities: In case DBA1 knows the DBKEY whereas DBA2 does not know it, DBA2 won't be able to start the database if this requires the entering of the DBKEY. The same is true for translating encrypted logs.
  • In case the database server runs with secured features, and a key is specified to allow secured features in particular cases, and only DBA1 knows this particular key for this (dbsrv12 -sk key), DBA2 cannot re-enable these features. (However, DBA2 might be able to start the database - or a copy - on his own without securing these features or with a different key).
  • In case the database contains data that is encrypted on an application level (i.e. outside the database), and DBA2 does not know about that encryption, then he cannot read the decrypted data (but could change it to anything else).
permanent link

answered 12 Feb '12, 17:13

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

edited 13 Feb '12, 10:44

Isn't this true for all user ids, DBA or otherwise? "cannot read the source of any object SET HIDDEN"

(13 Feb '12, 08:55) Breck Carter
Replies hidden

Yes, it is, but in contrast to others a DBA2 could still alter these objects...

But to clarify, I'm gonna change this to "anybody cannot" - as even DBA1 cannot un-do that operation.

(13 Feb '12, 09:02) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 12 Feb '12, 16:54

question was seen: 1,410 times

last updated: 13 Feb '12, 10:44