Example: Removing a User Override Option - Teradata VantageCloud Lake

Example: Creating a User with Default Storage creates the user user1 with default storage TD_OFSSTORAGE and an override option.

The following statement removes the override option:

MODIFY USER user1 AS
  DEFAULT STORAGE TD_OFSSTORAGE OVERRIDE NOT ON ERROR;

Without the override option, the following statements are no longer equivalent. The first statement creates the table user1.tb1 as an Object File System table by default, but the second statement fails because an Object File System table cannot have a primary index.

CREATE TABLE user1.tb1 (a INT, b INT) NO PRIMARY INDEX;

CREATE TABLE user1.tb1 (a INT, b INT) PRIMARY INDEX (a);