Revoking delete causes Error 580
Posted in 2000
If the DBA ( where DBA = my user name) tries to - " revoke delete on
table from DBA " error 580 occurs - cannot revoke permission and none
of the conditions in the error 580 description are true in this case.
I am the DBA, owner of the database and table, and am able to - "
revoke delete on table from public" -- or another user as long as thatuser has been granted the privilege I am revoking.
However, I am still able to delete from this table and I would like to
revoke my delete privileges - I do not want to accidentally delete fromcertain tables either from a Perform screen or an SQL statement.
Is this because as DBA, the DBA cannot revoke permission from himself
or herself?
For example, I tested the following:
1) Revoked all on table
2) Then selected for that table in systabauth (and syscolauth) and found
no rows.
3) Granted delete to DBA
4) Still found no rows.
Other than creating a database or table under another user's ownership
or logging in as another user, is there any way to accomplish this DBA
revoking of a the same DBA's delete privilege?
I am using SE and SQL version 7.20.UD1.