At 01:44 AM 25-03-02 -0400, Claudio Valderrama C. wrote:

>""Sandeep"" <sandeep@...> wrote in message
>news:3C9F5AD8.29216.2047A16@localhost...
> > If I restore a database why do I lose all the grants on all its objects?
>
>You shuld make sure the db you backed up has the grants you want.
>:-)
>
>I never have lost the SQL rights. Gbak keeps them carefully.

Of course, you will "lose" all the grants if you restore the DB onto a
server where the privileged user doesn't exist. :))

H.

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________