Subject | RDB$USER_PRIVILEGES - RDB$OBJECT_TYPE |
---|---|
Author | Simon Carter |
Post date | 2005-10-17T09:04:23Z |
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/
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/