Add support for Permissions tab in Procedure just like tables.
The following databases have permissions tab supported in the Procedure dialog:
DB2 8.1+, Informix, SQL Server, Oracle, Sybase Anywhere/ASE/IQ and Teradata.
The only known problem is Informix implementation cannot handle permissions for procedures with the same name but different parameter types. I will track this problem as a separate issue.
New code is checked in as SVN revision 9807 of ADS trunk.
New code is checked in as SVN revision 9807 of ADS trunk.
Known problems: on SQL Server and Sybase ASE
- object permissions granted to the user 'dbo' are not displayed (neither Procedure dialog nor User dialog)
Known problems: on SQL Server and Sybase ASE
- object permissions granted to the user 'dbo' are not displayed (neither Procedure dialog nor User dialog)
This is the only problem I found. Fung, can you please check ?
Cant give permission to a role in informix stored procedure
Informix_11_38
demo - informix
Procedures fx_hello_world
alter to give permission to Role
but when I click Role properties - it doesnt display
GRANT EXECUTE ON PROCEDURE informix.fx_hello_world (varchar) TO "role1" AS "informix"
GO
This is the only problem I found. Fung, can you please check ?
Cant give permission to a role in informix stored procedure
Informix_11_38
demo - informix
Procedures fx_hello_world
alter to give permission to Role
but when I click Role properties - it doesnt display
GRANT EXECUTE ON PROCEDURE informix.fx_hello_world (varchar) TO "role1" AS "informix"
GO
Issue #2938 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
The following databases have permissions tab supported in the Procedure dialog:
DB2 8.1+, Informix, SQL Server, Oracle, Sybase Anywhere/ASE/IQ and Teradata.
The only known problem is Informix implementation cannot handle permissions for procedures with the same name but different parameter types. I will track this problem as a separate issue.