Error 1000231

"You do not have permission to create join index %2%3%4. %1"

Item	Description
SQLCode	-1000231L
Constant	EMSG_SQL_JOINNOPERM
SQLState	QDC31
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	20891
Severity Code	14
Parameter 1	location of the exception
Parameter 2	userid of join index
Parameter 3	separator between userid and join index name
Parameter 4	join index name

Probable cause

A user can only create a join index under the following conditions 1) They are the DBA account 2) They have DBA authority. 3) They did not specify a creator and have RESOURCE authority 4) The specified creator is the same as the current user and they have RESOURCE authority.