Privileges to run an ALTER TABLE command

[ddrillich]

Good Day,

I'm trying to run the following -

ALTER TABLE xm_uds_deployrequest MODIFY scheduled_time DEFAULT SYSDATE

Which privileges are needed on the DB and how can I find whether I have them?

Regards,
Dan

 

[ddrillich]

All, it's interesting - the change did take place.

Regards,
Dan

 

[SantaMufasa]

Dan,

The owner of a table has all privileges on that table. So, if you, as the owner of table "xm_uds_deployrequest" attempt to make such a modification, it is not surprising.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.