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