Strange: Group privileges are ignored for CREATE VIEW

December 16, 2006

SQL0551N <user_name> does not have the privilege to perform operation “SELECT” on object
<table_name> <table_name>

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 🙂

Update: Similar symptom while trying to INSERT from a Stored Procedure, the user should be granted INSERT cannot just be part of the group that has INSERT access.

tags: ,
posted in DB2 by Visu

Follow comments via the RSS Feed | Leave a comment | Trackback URL

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org