Error Messages Associated with SQLSTATE 42501

This topic lists the errors associated with the SQLSTATE 42501.

SQLSTATE 42501 Description

ERRCODE_INSUFFICIENT_PRIVILEGE

Error messages associated with this SQLState

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 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 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
ERROR 9085: Must be superuser to alter subcluster
ERROR 9086: Must be superuser to create subcluster
ERROR 9087: Must be superuser to drop subcluster
ERROR 9359: User may not have read privilege to the file: [ string ]
ERROR 9373: Must be superuser to alter other users
ERROR 9374: Must be superuser to view other users
ERROR 9375: Must have superuser privileges to set configuration parameter string at the user level

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