View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000060 | Database Workbench v5 | General | public | 2011-07-28 00:50 | 2014-09-09 13:31 |
| Reporter | Bob Taylor | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | Windows | OS | 7 Enterprise 64-bit | OS Version | SP 1 |
| Fixed in Version | 5.0 | ||||
| Summary | 0000060: Let the Grant Manager support column-level privileges | ||||
| Description | In Firebird, I can grant column-level update privileges on a table. Here is an example: GRANT SELECT, UPDATE(COL1, COL2), REFERENCES ON MY_TABLE TO USER01; The Grant Manager only seems to operate at the table level. It does not have the capability have selecting specific columns to be included in an UPDATE grant. | ||||
| Additional Information | The workaround for this is to create column-level grants using the Script Editor. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-07-28 00:50 | Bob Taylor | New Issue | |
| 2011-07-28 10:00 | Martijn Tonies | Severity | minor => feature |
| 2011-07-28 10:00 | Martijn Tonies | Status | new => acknowledged |
| 2011-07-28 10:00 | Martijn Tonies | Category | Firebird Module => General |
| 2011-07-28 10:00 | Martijn Tonies | Platform | WIndows => Windows |
| 2011-07-28 10:00 | Martijn Tonies | Summary | Grant Manage does not support column-level update privileges => Let the Grant Manage support column-level privileges |
| 2013-05-01 14:26 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2013-12-04 14:54 | Martijn Tonies | Status | acknowledged => resolved |
| 2013-12-04 14:54 | Martijn Tonies | Fixed in Version | => 5.0 |
| 2013-12-04 14:54 | Martijn Tonies | Resolution | open => fixed |
| 2013-12-04 14:54 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2014-07-07 16:18 | Martijn Tonies | Summary | Let the Grant Manage support column-level privileges => Let the Grant Manager support column-level privileges |
| 2014-09-09 13:31 | Martijn Tonies | Status | resolved => closed |
