Add support for Permissions tab in View just like tables.
Permissions tab now is enabled in the View dialog for all of supported databases except Apache Derby, and MySQL 4.1; available in revision 9768 or newer ones in ADS trunk.
NOTES for DB2 and Informix:
---------------------------
These databases perform 'ALTER VIEW' as 'DROP followed by CREATE', special user interaction is required in order to generate permission script correctly.
(1) You need to click the Permissions tab at least once.
(2) You need to select each item listed in the 'Permissions for Grantee Type' at least once. (DB2: Users and Groups, Informix: Users and Roles).
This is because permission scripts are generated based on the data loaded in the memory which is triggered by tab clicking and grantee type combo box selection. If the Permissions tab is not clicked, no permissions will be generated. Similarly, if a grantee type combo box item is never selected, corresponding permissions (if any) will be lost during script generation.
Niels, please take a look at the Permissions tab implemented in the following databases:
PostgreSQL 7.3.3:
'WITH GRANT OPTION' is not supported by 7.3.3 but ADS UI allows it.
Since 7.3.3 User Node does not support 'Alter User', I am not sure
whether I should enable the Permissions tab in View for 7.3.3.
If we do, should we fix this problem?
Sybase ASE 11.0
Sybase ASE 12.5
Grant permission to User does not seem to work in 11.0 and 12.5.
Neither in the User Dialog nor in the View dialog.
Not sure whether this is a bug or not.
Niels, please take a look at the Permissions tab implemented in the following databases:
PostgreSQL 7.3.3:
'WITH GRANT OPTION' is not supported by 7.3.3 but ADS UI allows it.
Since 7.3.3 User Node does not support 'Alter User', I am not sure
whether I should enable the Permissions tab in View for 7.3.3.
If we do, should we fix this problem?
Sybase ASE 11.0
Sybase ASE 12.5
Grant permission to User does not seem to work in 11.0 and 12.5.
Neither in the User Dialog nor in the View dialog.
Not sure whether this is a bug or not.
Known problems: on SQL Server and Sybase ASE
- object permissions granted to the user 'dbo' are not displayed (neither View dialog nor User dialog)
Known problems: on SQL Server and Sybase ASE
- object permissions granted to the user 'dbo' are not displayed (neither View dialog nor User dialog)
Tested Permissions for all databases all versions.
1. Was able to grant permissions to views in Sybase ASE 11.0 for dbo Schema. See View permissions for dbo.FinalView
For other views in schemas like example_user - the permission is displayed, after I alter successfully.
2. SQL Server and Sybase ASE - permissions granted to dbo, INFORMATION_SCHEMA not displayed
3. SQL Server 2008 AdventureWorksLT2008 database- There are Schemas like bata, SalesLT, AUG_BETA - but there are not displayed in permissions tab of Views.
4. For Informix 11.5 Schema tariq, View tariq.V11, when I try to alter the permission, I always get this error
>[Error] Script lines: 7-8 --------------------------
No GRANT option or illegal option on multi-table view.
The SQL produced is :
DROP VIEW "tariq".v11
GO
CREATE VIEW "tariq".v11 (a) as select x0.a from "tariq".b1 x0 ;
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON tariq.v11 TO "tariq" WITH GRANT OPTION
GO
Tested Permissions for all databases all versions.
1. Was able to grant permissions to views in Sybase ASE 11.0 for dbo Schema. See View permissions for dbo.FinalView
For other views in schemas like example_user - the permission is displayed, after I alter successfully.
2. SQL Server and Sybase ASE - permissions granted to dbo, INFORMATION_SCHEMA not displayed
3. SQL Server 2008 AdventureWorksLT2008 database- There are Schemas like bata, SalesLT, AUG_BETA - but there are not displayed in permissions tab of Views.
4. For Informix 11.5 Schema tariq, View tariq.V11, when I try to alter the permission, I always get this error
>[Error] Script lines: 7-8 --------------------------
No GRANT option or illegal option on multi-table view.
The SQL produced is :
DROP VIEW "tariq".v11
GO
CREATE VIEW "tariq".v11 (a) as select x0.a from "tariq".b1 x0 ;
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON tariq.v11 TO "tariq" WITH GRANT OPTION
GO
Postgresql 7.3.3 is an old database. It is acceptable the way it currently is.
Sybase 11 and 12.5. I also had trouble granting permissions to some of the views. They were old views. I dropped them and created them again and then I was able to give them permission. Problem solved. :)
Postgresql 7.3.3 is an old database. It is acceptable the way it currently is.
Sybase 11 and 12.5. I also had trouble granting permissions to some of the views. They were old views. I dropped them and created them again and then I was able to give them permission. Problem solved. :)
Issue #2936 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Permissions tab now is enabled in the View dialog for all of supported databases except Apache Derby, and MySQL 4.1; available in revision 9768 or newer ones in ADS trunk.
NOTES for DB2 and Informix:
---------------------------
These databases perform 'ALTER VIEW' as 'DROP followed by CREATE', special user interaction is required in order to generate permission script correctly.
(1) You need to click the Permissions tab at least once.
(2) You need to select each item listed in the 'Permissions for Grantee Type' at least once. (DB2: Users and Groups, Informix: Users and Roles).
This is because permission scripts are generated based on the data loaded in the memory which is triggered by tab clicking and grantee type combo box selection. If the Permissions tab is not clicked, no permissions will be generated. Similarly, if a grantee type combo box item is never selected, corresponding permissions (if any) will be lost during script generation.