grant create view in Sybase IQ

Question

i'm trying granting a group to create view in Sybase IQ :

grant create view to groupname

it show error :

error near 'create' on line 1

how to do it?

Answer 1

In the version you are using, you cannot grant only the ability to create a view. The permissions structure was must less granular until version 16, so you will need to grant resource authority to the user/group using grant resource to groupname.