Product: Aqua Data Studio
Version: 17.0.0-dev-74
Operating Environment: Ubuntu-14.04LTS
Linux (3.13.0-41-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=389,545,984; Free=215,466,152; CPUs=8
Reproducible in Teradata-15.0
Connect Teradata-14.10
Create store procedure
CREATE PROCEDURE samplesp1 ()
BEGIN
/* SPL Statements*/
DECLARE V1 INTEGER;
SET V1 = 100;
END;
Go
Create Role
CREATE ROLE "Test_Role"
GO
GRANT "Test_Role" TO "DBC" WITH ADMIN OPTION
GO
GRANT "Test_Role" TO "tduser"
GO
Go to security node
Expand Role node
Right click "Test_Role"
Select Alter Role option
In Alter Role tab,Click on Object permission button
Select Database from database drop-down
Select Procedure object Objects drop-down
Check Drop permission for procedure
Click on Alter button
Here,You will observe that,Give error meassge"[Teradata Database] [TeraJDBC 15.00.00.20] [Error 3706] [SQLState 42000] Syntax
error: expected something between the word 'sqlscript' and '.'."
Incorrect Sql script generated in preview sql tab.
Expected script:
GRANT DROP PROCEDURE ON "sqlscript"."samplesp1" TO "Test_Role"
GO
Object Name scripting fixed. DDL should script correctly now...