ASTER Table Ownership

Aster
Highlighted
Enthusiast

ASTER Table Ownership

Hi,

Has an Aster table a creator who is the owner of the table ?

If yes, how to find the user who created a table using nc_system tables or views ?

I just couldn't find it in the docs.

Thanks,

 

Hum ... a closer look at nc_system tables is a good answer ...

see column "tableowner" in nc_user_tables

Pierre

 

1 REPLY
Teradata Employee

Re: ASTER Table Ownership

Yes, tableowner column is right.

 

You can also use nc_all_tables if your db user is members of catalog_admin and db_admin. 

nc_user_tables returns only tables which the user has privileges to view.