"Nataraj S Narayanan" <nataraj@...> wrote in message
news:Pine.LNX.4.21.0203241558240.841-100000@......

>
> I had to backup and restore a 45 Mb gdb ,after which when i execute the
> delphi/bde application I get a message

The first step to post a question is identifying the engine. Are you using
Interbase? Are you using Firebird? Which version and (if possible) which
build?

> "Insufficient Sql rights for operation no permission for write access to
> column USER_ID"

The Firebird's isql has a command
SHOW GRANTS;
that will list anything (excluding sysdba rights) and
SHOW GRANTS object;
to list only the rights to that object. Assuming USER_ID is on table T1, you
can do
show grants t1;
on your original and new db and see if something changed.

> Could it be due to any data corruption that an error which was not seen
> before
> backup and restore came up now?

Maybe, but who created the db, the same user that did the backup/restore?

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing