Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Friday, 24 July 2015

Error 3523: User does not have Select Grant Option on the table in Teradata

3523 error will come when the permission/access is denied for the user.

The user does not have the proper access rights to execute this request, or the owner of the requested view or macro does not have the proper access rights to underlying tables.

To solve above error you will have to give rights to that DB SELECT WITH GRANT OPTION on the table you are accessing. This can be done by your DBA.
Please provide your feedback in the comments section above. Please don't forget to follow.