Mar 10th, 2010, 7:25 AM
Thanks for your input. I own the server and as such, it is totally within my control and in most cases, including this one, I set myself up with all priviledges, including ALTER.
Thanks
Dave
Thanks
Dave
(Mar 10th, 2010, 1:19 AM)maxcreigs Wrote: Are you sure you have Alter privileges on that classic table?
If not, do you have "ALTER ANY TABLE" privileges?
If that doesn't work, maybe you need the CREATE ANY INDEX privilege.
In addition, if you are not the owner of the table, you need the DROP ANY TABLE privilege