Archives of the TeradataForum
Message Posted: Thu, 06 Dec 2007 @ 18:16:05 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|