Introducing Radical.sh
Forget Code launches a powerful code generator for building API's
Checking Rights in Teradata
DBC.allrights table will have the details like,
| Details |
|---|
| UserName |
| DatabaseName |
| TableName |
| ColumnName |
| AccessRight |
| GrantAuthority |
| GrantorName |
| AllnessFlag |
| CreatorName |
| CreateTimeStamp |
- SELECT *
- FROM dbc.allrights
- WHERE username='user-id'
- AND databasename='database-name'