Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 21:29:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Alan,

I am midst of developing something like this for our Security Administrators.

One assumption is that DBA would have created required set of Roles for administrating the grants.

I am not taking Individual Database table grants (This can be easily enhanced-matter of modifying the stored procedure).

The way I have restricted the security administrators to have permissions is by using Stored procedures. The stored procedure would be created by DBA and are parameterized.

DBA has all grants to the underlying tables and databases! The security administrator would just need execute stored procedure on this DBA stored procedure.

I would have loved to do this in a more robust UI but I am using VBA in excel to satisfy our needs for now.

Hope this helps.

Thanks,

Vinay Bagare

	<Prev	Next>		<<First	<Prev	Next>	Last>>