All Forums Database
acumens 4 posts Joined 03/12
15 Oct 2014
how/where to find inherited rights acquired by user when created?

dear friends,
when i create an user in Teradata, its automatically interiting/acquiring all access on super user DBA without explaicitly granting anything.. we have 3 enrironments dev, test and prod and this is happening only in test env not others.. I dount something on env level settings but unsure where to check and restrict access on super user as it's a security constraint.. i tried various posts searching google but dint get concrete info.. please help
- regrads,krisv

dnoeth 4628 posts Joined 11/04
16 Oct 2014

Check the rights granted to PUBLIC or granted with the ALL option, dbc.AllRightsV.AllnessFlag = 'Y'

Dieter

acumens 4 posts Joined 03/12
20 Oct 2014

Hi Dieter,
Thanks a lot for reply. I checked PUBLIC rights, It's having access on all DBC objects and other System* user objects. AllnessFlag='N' only. No diff b/w test and other env entries for PUBLIC. Pls. let me know if I need to provide more info
 
Regards-Kris

acumens 4 posts Joined 03/12
23 Oct 2014

Hi Dieter/Friends,
any other suggestions? Kindly help.. thanks

You must sign in to leave a comment.