Fallback Table Restriction in System

Database
Teradata Employee

Fallback Table Restriction in System

Hi All,

Can we restrict Fallback table creation in system at user level or system level.?

I mean: Is there any way so that we can restrict users to create fallback table in system ? any DBScontrol parameter ?

Please suggest.

3 REPLIES
Teradata Employee

Re: Fallback Table Restriction in System

Hi Experts,

Any suggestion ??

Senior Apprentice

Re: Fallback Table Restriction in System

Hi Sandeep,

no, you can't.

Simply set the database default to NO FALLBACK and hope the end users don't overwrite it.

Maybe add a scheduled job which mails the users when they do and submits ALTER TABLE, NO FALLBACK... 

Teradata Employee

Re: Fallback Table Restriction in System

Thanks Dnoeth.

but there is one DBS Control Parameter in Internal Group-113.

This parameter has three values. But it is not fulfil my requirment as it help in fallback direction.