Saturday, December 16, 2006

Strange: Group privileges are ignored for CREATE VIEW

SQL0551N does not have the privilege to perform operation "SELECT" on object

If a user receives this error while creating views, make sure the user is granted SELECT privilege individually. Group privileges are not considered for any table or view specified in the CREATE VIEW statement.

No, its not a bug. Its documented :)