|
|
Archives of the TeradataForum
Message Posted: Mon, 10 Dec 2007 @ 19:04:05 GMT
Subj: | | Re: Privileges required to "Grant Index access on a table" |
|
From: | | Geoffrey Rommel |
| I'd just mention that the syntax looked strange to me and I did a full-text search on the Teradata documentation site on the phrase "grant
index". | |
Refer to the DDL manual (SQL Reference: Data Definition Statements), V2R6.2 (Sep. 2006), chap. 5, PDF page 1029. The word GRANT can be followed
by a 'privilege'; two pages later, the privileges are listed, and one of them is INDEX. As mentioned before, this appears as 'IX' in the
AccessRights table.
| |