Error Messages Associated with SQLSTATE 42501

This topic lists the errors associated with the SQLSTATE 42501.

SQLSTATE 42501 Description

ERRCODE_INSUFFICIENT_PRIVILEGE

ERROR 2065: string: Invalid table/projection/column string

ERROR 2198: analyze_statistics: Requires modify permissions for table/projection/column string

ERROR 2347: Cannot alter predefined role "string"

ERROR 2348: Cannot alter superuser string's default roles

ERROR 2349: Cannot alter superuser roles

ERROR 2389: Cannot create system built-in tuning rule

ERROR 2419: Cannot drop system built-in tuning rule

ERROR 2460: Cannot move user string to general pool, they lack privileges

ERROR 2481: Cannot remove memoryCap

ERROR 2482: Cannot remove runTimeCap

ERROR 2484: Cannot remove tempSpaceCap

ERROR 2515: Cannot set resource pool: user string lacks privileges on resource pool string

ERROR 2812: Could not add location [string]: Permission denied

ERROR 2935: Couldn't nice(value) thread: value

ERROR 2953: Current password must be supplied to set new password

ERROR 2958: Current user can't change runtime priority of another user's task

ERROR 2960: Current user doesn't have the privilege to change the task runtime priority to be higher than its resource pool

ERROR 3577: Insufficient permissions on projection "string"

ERROR 3578: Insufficient permissions on schema "string"

ERROR 3579: Insufficient permissions on table "string"

ERROR 3580: Insufficient privilege: USAGE on SCHEMA 'string' not granted for current user

ERROR 3581: Insufficient privileges for projection string

ERROR 3582: Insufficient privileges for table string

ERROR 3583: Insufficient privileges on string

ERROR 3584: Insufficient privileges on string, modify privileges (INSERT|UPDATE|DELETE|TRUNCATE) needed

ERROR 3722: Invalid passphrase: string

ERROR 3919: memoryCap of value KB would exceed user limit of value KB

ERROR 3989: Must be owner of string string

ERROR 3990: Must be owner of string [string]

ERROR 3991: Must be superuser to alter database

ERROR 3992: Must be superuser to alter profile

ERROR 3993: Must be superuser to alter tuning rule

ERROR 3994: Must be superuser to alter user default roles

ERROR 3998: Must be superuser to clear Query/EE profiles

ERROR 4000: Must be superuser to create interface

ERROR 4001: Must be superuser to create library

ERROR 4002: Must be superuser to create profile

ERROR 4003: Must be superuser to create subnet

ERROR 4004: Must be superuser to create tuning rule

ERROR 4005: Must be superuser to create users

ERROR 4006: Must be superuser to drop an interface

ERROR 4007: Must be superuser to drop library

ERROR 4008: Must be superuser to drop profile

ERROR 4009: Must be superuser to drop resource pool

ERROR 4010: Must be superuser to drop role

ERROR 4011: Must be superuser to drop subnet

ERROR 4012: Must be superuser to drop tuning rule

ERROR 4013: Must be superuser to drop users

ERROR 4014: Must be superuser to modify resource pools

ERROR 4015: Must be superuser to rename interface

ERROR 4016: Must be superuser to rename profile

ERROR 4017: Must be superuser to rename role

ERROR 4018: Must be superuser to rename subnet

ERROR 4019: Must be superuser to run string

ERROR 4020: Must be superuser to run analyze_workloadstring()

ERROR 4059: New runTimeCap value ms would exceed user limit of value ms

ERROR 4061: New tempSpaceCap value KB would exceed user limit of value KB

ERROR 4178: Not enough privileges for projection string

ERROR 4179: Not enough privileges for table string

ERROR 4244: Only database superuser can drop procedures

ERROR 4260: Only superuser can check privileges on other users

ERROR 4261: Only superuser can create roles

ERROR 4269: Only the database super user can create procedures

ERROR 4366: Permission denied

ERROR 4367: Permission denied for string string

ERROR 4368: Permission denied for string [string]

ERROR 4369: Permission denied to create temporary tables

ERROR 4370: Permission denied: "string" is a system catalog

ERROR 4546: RecvFiles on string: Can't write to file [string]

ERROR 4741: setThreadCPUNiceValue: couldn't nice(value) thread: value

ERROR 4742: setThreadIONiceValue: couldn't ionice(value) thread: value

ERROR 5149: Unable to set role "string"

ERROR 5389: User has insufficient privileges on schema string

ERROR 5488: Workspace schema string does not exist

ERROR 5517: Your Vertica license is invalid or has expired

ERROR 5618: Must be superuser to alter fault group

ERROR 5619: Must be superuser to create fault group

ERROR 5620: Must be superuser to drop fault group

ERROR 5635: Path to file [string] contains a symbolic link

ERROR 5716: Must have create permissions in schema string to drop type

ERROR 5818: Deployment script will not be generated since the user does not have appropriate permissions to write to [string]

ERROR 5820: Design script will not be generated since the user does not have appropriate permissions to write to [string]

ERROR 5956: Must be superuser to ALTER NODE

ERROR 5957: Must be superuser to create filesystem

ERROR 5958: Must be superuser to create location

ERROR 5959: Must be superuser to CREATE NODEs

ERROR 5961: Must be superuser to supply 'user_name' argument to HAS_ROLE() function
    HINT: Non-superusers run HAS_ROLE('role_name')

ERROR 5975: Not enough privileges for string

ERROR 6125: Access Policies are not enabled

ERROR 6343: Must be superuser to string authentication

ERROR 6344: Must be superuser to alter access policy

ERROR 6345: Must be superuser to alter authentication

ERROR 6346: Must be superuser to copy access policy

ERROR 6347: Must be superuser to create access policy

ERROR 6348: Must be superuser to create authentication

ERROR 6349: Must be superuser to drop access policy

ERROR 6350: Must be superuser to drop authentication

ERROR 6351: Must be superuser to rename authentication

ERROR 6514: Must be superuser to run value <name not available>

ERROR 6540: string: Invalid external table string

ERROR 6871: Must be superuser to rename user

ERROR 6872: Must be superuser to run move_statement_to_resource_pool

ERROR 6896: Parameter string can be cleared only via a UDx

ERROR 6897: Parameter string can be set only via a UDx

ERROR 6902: Permission denied on [string.string]

ERROR 6903: Permission denied, must be superuser to create a directed query

ERROR 6904: Permission denied, must be superuser to drop a directed query

ERROR 6905: Permission denied, must be superuser to save a query

ERROR 6906: Permission denied, must be superuser to update directed query status

ERROR 7376: Cannot close other user's sessions

ERROR 7463: Must be superuser to create notifier

ERROR 7464: Must be superuser to drop notifier

ERROR 7998: Permission denied for model string

ERROR 7999: Permission denied for schema string

ERROR 8569: Can't create the file [string]

ERROR 8854: Must be superuser to create branch

ERROR 8855: Must be superuser to create load balance groups

ERROR 8856: Must be superuser to create routing rules

ERROR 8857: Must be superuser to drop a load balance group

ERROR 8858: Must be superuser to drop a routing rule

ERROR 8859: Must be superuser to drop branch

ERROR 8929: Alter address sub-command not recognized

ERROR 8935: Cannot override ImportExportTLSMode when set to string

ERROR 8958: Insufficient privileges on string, alter privileges needed

ERROR 8959: Insufficient privileges on string, drop privileges needed

ERROR 8963: Load balance group type "string" cannot have a filter set

ERROR 8964: Must be superuser to alter load balance group

ERROR 8965: Must be superuser to alter network address

ERROR 8966: Must be superuser to alter routing rule

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.