FAQ: Can privileges be revoked on the GDB_HISTORICALMARKERS table?
Can privileges be revoked on the GDB_HISTORICALMARKERS table?
It is common practice to limit the privileges granted on the ArcSDE repository tables and seek to remove SELECT, UPDATE, INSERT and DELETE privileges on the repository tables.
However, the following privileges are required on the GDB_HISTORICALMARKERS repository table in order to perform certain operations. These privileges can be granted to individual users or to roles. For example, in Oracle, SELECT, UPDATE, INSERT, and DELETE are granted to the PUBLIC user, but many choose to revoke these privileges from PUBLIC and explicitly grant them to the users performing the archiving operations.
If these operations are not being performed, privileges to the GDB_HISTORICALMARKERS table can be revoked. For example, if a user is not allowed to create new historical markers, the INSERT privilege can be revoked.