CODEWITHSUNDEEP
sqlpermissionsteradata
Joe
Joe

Reputation: 13111

Teradata - granting access to user table without user being involved

If someone created a table in userspace (e.g. UD123 with naming convention EID_table_name) and that person left the company - is there a way to grant select permission to that table to some other user?

Upvotes: 0

Views: 1260

Answers (1)

Rob Paller
Rob Paller

Reputation: 7786

By default, DBC should have sufficient access to grant access to another user. If that is not feasible, you can query the DBC.AllRightsV to see who has Grant Authority on the user database and the objects contained within.

SELECT *  
  FROM DBC.AllRightsV 
 WHERE DatabaseName = ‘{UserID}’ 
   AND GrantAuthority = ‘Y’;

Upvotes: 2

Related Questions