Re: Permissions on views

Posted in 1991

Alan Denney — Tue, 15 Oct 91 15:29:28 PDT — source: Informix-list mailing list archive (1991-1998)

>> From uunet!rmy.emory.edu!informix-list-owner Tue Oct 15 12:56:11 1991 >> From: Tony Heskett <uunet!lhr-sys.ssf-sys.DHL.COM!theskett> >> Subject: Permissions on views >> To: informix-list@rmy.emory.edu >> >> Nigel Brickenden <brick@bcr.bellcore.com> writes (quoting me) >> >> > This is incorrect. You can have select permission on a view without having >> > select permission on the base table(s) that the view is constructed on. >> >> I thought that they were meant to work like paragraph 2, but ... >> >> <script omitted> >> >> Now log in as yourself, run isql and do "select * from blug". >> Isql comes back with "272: No select permission" I would guess that you are running an old version. This works as expected in 4.0 and 4.1. I just verified using 4.00.UH1. The stated functionality was changed in 4.0; earlier behavior was clearly a bug when you take the SQL standard into account. >> Cheers - Tony. >> Tony Heskett: theskett@lhr-sys.ssf-sys.dhl.com | Vox: (+44) 81 747 8330 -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "Terrific! I'm about to get killed a million miles from home while a gung-ho iguana tells me to 'relax'!!" - The Last Starfighter