CODEWITHSUNDEEP
sqlteradata
Samoth
Samoth

Reputation: 460

What permissions do I need to use the SHOW TABLE command in Teradata?

What permissions do I need to use the SHOW TABLE command in Teradata?

I've looked in the Teradata Data Dictionary, the Teradata Administrator User Guide and searched on Google, but I can't find any documentation for this.

I'm getting the error:

The user does not have any access to xxx.yyy

Upvotes: 2

Views: 5090

Answers (1)

Raj
Raj

Reputation: 22946

The SHOW privilege, available at the table level and database level, allows a user to see the table definition and access DCL statements (such as SHOW TABLE, HELP TABLE, HELP STATS, and so on) without having SELECT access to a table. Grant the SHOW privilege to a developer or service personnel to allow access to information about an object and see the structure, but not have any actual access to any of the data. Any user with the "WITH GRANT" option can grant the SHOW privilege to others.

The following is the syntax to grant show table on a single table to a user.

GRANT SHOW ON TableName TO UserName

The following is the syntax to grant show table for all the tables in a database to a user.

GRANT SHOW ON DatabaseName TO UserName

Upvotes: 4

Related Questions