Subject | FB 1.5.3 privileges remain after column drop |
---|---|
Author | Paweł Świerzko |
Post date | 2007-02-27T15:26:55Z |
Hi,
Firebird 1.5.3
1. I grant update or refernces rights to a table column,
2. I drop the column from the table.
3. try backup
4. on restore there is a fault to grant rights on nonexisting column.
after inspection i discovered that dropping column doesn't remove grants
from rdb$user_privileges.
but fortunately if I drop whole table then all grants are removed.
I have found description of it in 2.0 pre-release notes as fixed regression,
but
nothing about 1.5 version
Is it normal behaviour?
Pawel
Firebird 1.5.3
1. I grant update or refernces rights to a table column,
2. I drop the column from the table.
3. try backup
4. on restore there is a fault to grant rights on nonexisting column.
after inspection i discovered that dropping column doesn't remove grants
from rdb$user_privileges.
but fortunately if I drop whole table then all grants are removed.
I have found description of it in 2.0 pre-release notes as fixed regression,
but
nothing about 1.5 version
Is it normal behaviour?
Pawel