Archives of the TeradataForum
Message Posted: Wed, 04 Jun 2014 @ 15:36:16 GMT
Subj: | | Missing/Required Access Rights |
|
From: | | narayan.murthy |
We know how to get the current access rights for a given user from the dbc.accessrights table - but given a query type (say
INSERT/UPDATE/DELETE/CT/DT/CREATE INDEX/EXEC/CALL/....) - how will I know what access rights are required to execute this query type.
I want to know how we could get this info - so that we can ask the DBA to provide the necessary access rights - before I hit the error that I
dont have this right on that object .....
Is this documented somewhere.
Regards,
KSN
|