Rights held by DB/User

Database
Enthusiast

Rights held by DB/User

Teradata Administrator displays a useful panel showing the rights etc. held by a DB/User when you Right click on the DB/User and select 'Rights held by DB/User', is there a way to extract this sql so that I can run it elsewhere?

Thnx,
Marius

Database Object Column Access Grant/Role Grantor AllnessFlag
$XXX_ATL_EASTBOUND All All R XXX_Read Sys_Admin N
$XXX_ATL_WESTBOUND All All R XXX_Read Sys_Admin N
3 REPLIES
Enthusiast

Re: Rights held by DB/User

Looks like all the info comes from dbc.allrights, thanks anyway.
N/A

Re: Rights held by DB/User

Hi Marius, 

Are you sure it comes from dbc.allrights?

I don't think so.

When I create a new user, and then grant role to new user, I check from Rights held by DB/User, however, it's different result select * from dbc.allrights where username='new user';

Rights held by DB/User is more completely information. 

I need to know where exactly come from, anyone can follow up?

Thanks.

Junior Contributor

Re: Rights held by DB/User

Press F12 to get the SQL History window where you see all SQL submitted by TD Administrator.