Timeline for Auto-incremented ID with sequence and trigger: How to handle manual overrides (causing non-unique error)
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 15, 2017 at 4:31 | vote | accept | User1974 | ||
| Jun 29, 2017 at 14:08 | comment | added | markp-fuso | see revoke for more details, including revoking update of individual columns; your sequence/trigger applies for the insert so there should be no problems; obviously the easiest way to confirm all of this ... "When in doubt, try it out!" :-) | |
| Jun 29, 2017 at 14:00 | comment | added | User1974 | Is it possible to revoke privileges on a specific column? While still allowing the sequence & trigger to input the ID? | |
| Jun 29, 2017 at 13:47 | comment | added | User1974 |
Good ideas. Thanks. To answer your question, no, I don't think I need to allow users to update the PROJECT_ID column. As you've suggested, it would be nice to find an elegant way to prevent this.
|
|
| Jun 29, 2017 at 1:40 | history | answered | markp-fuso | CC BY-SA 3.0 |