Archives of the TeradataForum
Message Posted: Thu, 03 Apr 2008 @ 10:59:56 GMT
Subj: | | Can TDWM limit grant/revoke access rights |
|
From: | | Okell, Alan |
I suspect the answer is 'no' but does anybody know if it possible to use TDWM to limit users ability to Grant / or Revoke Access Rights. I've
checked the doc'n and its not explicitly covered.
On a more general security point, how are other sites handling the 'With Grant Option' users automatically receive when Creating a Table. We
have users who have access to sensitive customer data and those who don't, and the goal is to remove the ability of users with access to sensitive
data to grant that access to others.
Apart from going in and revoking these 'With Grant option' access rights following each Create table, supported by monitoring and reporting,
I'm not sure how else this could be done.
Any ideas ?
|