alter table error
 

Hi,

I have a database which i switched from one system to the other and i when i tried the alter table command for adding a column an error is displayed as

I tried all other queries like update and insert and it's all working without flaw..

But alter is not working..

I couldn't find the exact error...Please help.


Regards
Rekha

Re: alter table error
 

It might so happen you do not have the permission to alter table

Re: alter table error
 

Hi,

Thanks for your reply.Can you tell me in detail why it is so.


Regards
Rekha

Re: alter table error
 

Your admin has created a low privileges user that you are using to login to the database server.

Also Remember to use the signatures for links to your site and not in posts as its against the forum guidelines.

Re: alter table error
 

Hi,

Then how can i solve this error.



Regards
Rekha

Re: alter table error
 

You need the permission and ask them from your database admin.

Re: alter table error
 

check that you import database schema in the same where it was located on previous sytem and also check that the previleges you have about database is good enough to make changes

Re: alter table error
 

Please check file permissions!