Archives of the TeradataForum
Message Posted: Mon, 13 Feb 2012 @ 16:29:53 GMT
| Subj: || || Re: How to clear the Orphan Access rights |
| From: || || Pluebell, Fred |
If you drop a table on which no privileges have been explicitly granted, Teradata uses PI access and RowHash locks to delete rows corresponding
to the automatic rights (inserted as part of the CREATE TABLE), rather than acquiring a table write lock on access rights and scanning the table
to delete any matching rights.
This is a major performance optimization for the log / error / work tables created by Teradata Utilities, for example. But as in the scenario
Geeta describes, it may rarely cause some "orphan" rows to be left behind. It's not a problem as long as the number of orphan rows remains very
small compared to the total size of AccessRights.