Teradata Stored Procedure Access Rights
When you write a stored procedure a very common consideration is regarding the access rights which should be granted to it. I wrote a post long back regarding SQL SECURITY option available in Teradata. Before going forward make sure to read it: SQL SECURITY OPTION FOR STORED PROCEDURE IN TERADATA . So now you are aware of four options available in Teradata for assigning proper permissions to it. Lets see a small example to check it.
=== Compile This Stored Procedure in Teradata ===
REPLACE PROCEDURE ACCESSRIGHTSINFO (OUT DBNAME VARCHAR(30))
SQL SECURITY DEFINER /* [OWNER, INVOKER, CREATOR] */
SEL DATABASE INTO :DBNAME;
=== Execute it to check the value of DEFINER ===
Change value to OWNER, INVOKER & CREATOR one-by-one and see the output returned.
With the output you can relate more to the concept of SQL SECURITY OPTION.
In case you need more clarity, feel free to leave a comment.