Re: View-Problem with 5.0

> We now detected a serios problem with Informix 5.0 using Views. > It seems to be a problem with the permissions. > There is a view specified only on 1 table. > The database, all tables and views are owned by 1 user. > Connect permission to the whole database is granted to public. > Sometimes all users except the owner get the message > 272 no SELECT permission > when trying to retrieve data via this view. Selecting directly from > the table is no problem!! This may be a result of the differences between a table and a view. When you create a table, Informix automatically grants select, insert, update and delete privileges to public for that table. When you create a view, NO automatic privileges are granted. The owner of the view must grant the privileges. ( See the Informix Guide to SQL, chapter 11, page 8 and 29) All users except the owner should get the -272 error message from the view even if they can select from the table. You need to grant privileges to users/public on the view before they can use them. This allows you to set different privileges for a view from its underlying tables. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Providing Informix Database Tools and Consulting # #############################################################################