If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > Ingres grants, iipermit and iitable catalogs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-15-02, 15:18
dmason7199 dmason7199 is offline
Registered User
 
Join Date: Jul 2002
Posts: 1
Ingres grants, iipermit and iitable catalogs

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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On