Subject RDB$USER_PRIVILEGES - RDB$OBJECT_TYPE
Author Simon Carter
If I run the following sql:

SELECT RDB$USER, RDB$GRANTOR, RDB$PRIVILEGE, RDB$GRANT_OPTION,
RDB$RELATION_NAME, RDB$FIELD_NAME, RDB$OBJECT_TYPE
FROM RDB$USER_PRIVILEGES
WHERE RDB$RELATION_NAME = 'VIEWNAME';

To retrieve permissions for a view, the RDB$OBJECT_TYPE column is set to 0
(zero). I expected it to be 1, to denote a view. With this in mind, to
determine whether an object is a view or table do I have to query
RDB$RELATIONS table for RDB$VIEW_BLR?

FYI I took a leap of faith on the value being 1 after looking at langref.pdf
(RDB$DEPENDENCIES table RDB$DEPENDED_ON_TYPE column) :-)

Rgds

Si Carter
http://www.fbtalk.net/
http://www.tectsoft.net/