0

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?

Improve this question
3
  • 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
1

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

Improve this answer
2
  • 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.