If I create a table T, I become the owner of the table.

Can DBA access T?

Can DBA also revoke my access or grant privileges on T?

  • 3
    Which DBMS are you using? – atokpas Oct 26 '16 at 7:19
  • I am not using any DBMS. I am just reading a book and this question came into my mind. The book follows SQL92. What happens in the DMBS you are most familiar with? – Sonu Mishra Oct 26 '16 at 7:21
  • 6
    They all work differently but, broadly speaking, a user with DBA privs can do anything – Philᵀᴹ Oct 26 '16 at 7:23

A user with DBA privillege can do anything. He can access or grant privillege of any table or database objects.

  • 2
    What is a DBA privilege? Do you mean something like sysdba, sa, superuser, super or similar? – dezso Oct 26 '16 at 8:20
  • yes the general privillege is this @dezso – Saddam Khan Oct 26 '16 at 8:31

Not the answer you're looking for? Browse other questions tagged or ask your own question.