Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2007 @ 18:16:05 GMT

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

Alan,

Yes, the current stored procedure could have grants to role. Again the stored procedure in question can be parameterized to pass the role name.

A dynamic SQL can easily be constructed and granted. As the SP is created by DBA (so is the role), you don't have to worry about the WITH grant option.

You would just need to grant an execute procedure call to the security administrator.

I have used this approach in past with great success and I am trying to build a UI (simple Excel based). I wish I had some .Net expertise!

HTH

Thanks,

Vinay Bagare

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