|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.openswing.swing.table.permissions.database.server.DefaultDbPermissionsDescriptor
Title: OpenSwing Framework
Description: Default descriptor of the table related to grid permissions storing, where the primary key is based on "functionId",role identifier attributes of the GridPermissions. The "id" can represent more than one database field.
it is based on a table having the following structure: CREATE TABLE GRID_PERMISSIONS(FUNCTION_ID VARCHAR,ROLE_ID VARCHAR,COLS_POS VARCHAR,EDIT_COLS_IN_INS VARCHAR,EDIT_COLS_IN_EDIT VARCHAR,REQUIRED_COLS VARCHAR,COLS_VIS VARCHAR,PRIMARY KEY(FUNCTION_ID,ROLE_ID)) Morever, a second table is needed, to map username with its roles: CREATE TABLE USER_ROLES(USERNAME VARCHAR,ROLE_ID VARCHAR,PRIMARY KEY(USERNAME,ROLE_ID)) Finally, a third table is needed, to store default settings for grid, in order to externally define roles in GRID_PERMISSIONS table: CREATE TABLE GRID_PERMISSIONS_DEFS(FUNCTION_ID VARCHAR,COLS_POS VARCHAR,EDIT_COLS_IN_INS VARCHAR,EDIT_COLS_IN_EDIT VARCHAR,REQUIRED_COLS VARCHAR,COLS_VIS VARCHAR,PRIMARY KEY(FUNCTION_ID))Copyright: Copyright (C) 2006 Mauro Carniel
This file is part of OpenSwing Framework. This library is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it
Constructor Summary | |
DefaultDbPermissionsDescriptor()
|
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public DefaultDbPermissionsDescriptor()
Method Detail |
public java.lang.String getGridPermissionsTableName()
getGridPermissionsTableName
in interface DbPermissionsDescriptor
public java.lang.String[] getRoleIdFieldNamesInGridPermissionsTable()
getRoleIdFieldNamesInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getFunctionIdFieldNameInGridPermissionsTable()
getFunctionIdFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getColumnsAttributeFieldNameInGridPermissionsTable()
getColumnsAttributeFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getEditableColumnsInEditFieldNameInGridPermissionsTable()
getEditableColumnsInEditFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getEditableColumnsInInsertFieldNameInGridPermissionsTable()
getEditableColumnsInInsertFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getColumnsMandatoryFieldNameInGridPermissionsTable()
getColumnsMandatoryFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getColumnsVisibilityFieldNameInGridPermissionsTable()
getColumnsVisibilityFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.lang.String getColumnsHeaderFieldNameInGridPermissionsTable()
getColumnsHeaderFieldNameInGridPermissionsTable
in interface DbPermissionsDescriptor
public java.util.Hashtable deleteAllGridPermissions(java.lang.String functionId)
deleteAllGridPermissions
in interface DbPermissionsDescriptor
public java.lang.String getUserRolesTableName()
getUserRolesTableName
in interface DbPermissionsDescriptor
public java.lang.String getUsernameFieldNameInUserRolesTable()
getUsernameFieldNameInUserRolesTable
in interface DbPermissionsDescriptor
public java.lang.String[] getRoleIdFieldNamesInUserRolesTable()
getRoleIdFieldNamesInUserRolesTable
in interface DbPermissionsDescriptor
public java.lang.String[] getRolesWhereFieldNames()
getRolesWhereFieldNames
in interface DbPermissionsDescriptor
public java.lang.Object[] getRolesWhereValues()
getRolesWhereValues
in interface DbPermissionsDescriptor
public java.lang.String getGridPermissionsDefaultsTableName()
getGridPermissionsDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String getFunctionIdFieldNameInDefaultsTableName()
getFunctionIdFieldNameInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String[] getOtherFieldNamesInDefaultsTableName()
getOtherFieldNamesInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.Object[] getOtherFieldValuesInDefaultsTableName()
getOtherFieldValuesInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String getColumnsAttributeFieldNameInDefaultsTableName()
getColumnsAttributeFieldNameInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String getEditableColumnsInEditFieldNameInDefaultsTableName()
getEditableColumnsInEditFieldNameInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String getEditableColumnsInInsertFieldNameInDefaultsTableName()
getEditableColumnsInInsertFieldNameInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String getColumnsMandatoryFieldNameInDefaultsTableName()
getColumnsMandatoryFieldNameInDefaultsTableName
in interface DbPermissionsDescriptor
public java.lang.String getColumnsVisibilityFieldNameInDefaultsTableName()
getColumnsVisibilityFieldNameInDefaultsTableName
in interface DbPermissionsDescriptor
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |