dmason7199
07-15-02, 16:18
| Can anyone help my understanding here of the way that Ingres system catalogs display grant information? (Ingres 6.4/06) (1) Consider the following situation - a new table: * create table dm (x varchar(10)); commit\g Executing . . . continue * grant select on dm to public; commit\g Executing . . . continue * help permit dm\g Executing . . . Permissions on dm are: Permission 1: grant select on dm to public; continue * select count(*) from iipermits where object_name = 'dm'\g Executing . . . „¡„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„¢ „*col1 „* „¥„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§ „* 0„* „¤„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„£ (1 row) continue * select table_permits from iitables where table_name = 'dm'\g Executing . . . „¡„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„¢ „*table_„* „¥„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§ „*Y „* „¤„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„£ (1 row) continue * My question is - why does the grant I've just made not show up in iipermits although it does appear in the table_permits column in iitables? (2) Now consider the following - an existing table: * help permit workstation\g Executing . . . Permissions on workstation are: Permission 1: grant select on workstation to public; continue * select count(*) from iipermits where object_name = 'workstation'\g Executing . . . „¡„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„¢ „*col1 „* „¥„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§ „* 0„* „¤„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„£ (1 row) continue * select table_permits from iitables where table_name = 'workstation'\g Executing . . . „¡„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„¢ „*table_„* „¥„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§ „*N „* „¤„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„£ (1 row) continue My question here is - why does the table_permits column contain 'N' for this table even though the "help permits" command returns the grant? Is this a corruption? Many thanks for your help |