Access Right 'G' abbreviation

Database
Enthusiast

Access Right 'G' abbreviation

Hi

I have noticed an AccessRight 'G' in one of the tables.

May I know its abbreviation? I am unable to find the abbreviation anywhere else including the documentation.

Thanks

5 REPLIES
Enthusiast

Re: Access Right 'G' abbreviation

I am not sure, it can be for Global and Persistent data(GLOP). 

Teradata Employee

Re: Access Right 'G' abbreviation

Hi Nick2408,

the docs have following abbreviations - see Data Dictionary, Appendix A View Column Values:

GC - CREATE GLOP

GD - DROP GLOP

GM - GLOP MEMBER

Regards,

Vlad.

Enthusiast

Re: Access Right 'G' abbreviation

Hi Nick,

Which version of TD ? Sometime back someone asked the same question too. If they are not  GC,GD,GM then we need to know that G.

Enthusiast

Re: Access Right 'G' abbreviation

Its TD 14.10 and I have found the abbreviations of GC, GD and GM in the documentation but there is no reference about the access right G .

Junior Supporter

Re: Access Right 'G' abbreviation

In older Teradata releases, accessrights included the GRANT privilege, denoted as 'G'. Eventually, the functionality of GRANT was morphed into 'with grant option’.So "G" is now obsolete.It may be difficult to find how accessright  "G" originated on your system now.There is no revoke statement to get rid of it.It should be OK to drop the rows with privilege "G" because the privilege is deactivated.Since DBC.accessrights is a dictionary table, only GSC can delete this record using their internal procedure.

Regards,

Abhishek Jadhav


Abhishek Jadhav