Comentários (2)

1 DirkHerreman comentou às Link permanente

is this alter table statement not restricted to DBA (or some other higher level) privileges?

2 SergeRielau comentou às Link permanente


Dynamic SQL (by default) executes under the invoker's rights.
So as long as the user executing the procedure has the rights to:
* execute the routine
* select the identity column values from the table
* alter the table
They should be good to go.
This should not require the DBA.