Access Rights -- Inheriting nature

Database
Teradata Employee

Access Rights -- Inheriting nature

Hi,

I have give Stats access on A (DB) to all B (DB) with grant option...

Since, I wanted Stats access on all of the child DBs in A (DB) for B (DB), upon checking in AllnessFlag has Y (dbc.accessrights), but these rights are not getting inherited.

Is there any other to get Stats access inherited to all DBs in A(DB).

Thanks,

Venkat

1 REPLY
Junior Contributor

Re: Access Rights -- Inheriting nature

Hi Venkat,

"grant STATS on A to all B" only inherits the STATS right on A to all child users of B, but there's no way to get what you want using a single GRANT.

Dieter