SQL TOKEN -551 : Unable to create VIEWS

This post is especially for my readers who are new to the field of application database administration.  If you are mainly working with VIEWS in test/development/production and you as an application DBA's are responsible for granting appropriate access to the secondary authorization ID's then I am sure you would have come across requests for " granting access to create views " . I used to wonder what type of access is needed to create views ?

It may seem like a funny question if you already know the answer - but hey, there are guys out there who are new to these kind of requests you know.

OK - Here is the error message



All you need to do is grant SELECT access to the secondary auth ID ( APPLNID1 in this example) and boom !! Your application developer will be able to create views provided he/she is a part of the auth ID. You don't need to grant any other access unless and until the program performs DML activities on the views.

So now you know - You are not alone and you do have good help !!