Messages associated with SQLSTATE 42501

This topic lists the messages associated with the SQLSTATE 42501.

SQLSTATE 42501 description

INSUFFICIENT_PRIVILEGE

Messages associated with this SQLState

Error messages

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 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 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 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 4260: Only superuser can check privileges on other users
ERROR 4261: Only superuser can create roles
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 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 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 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 6345: Must be superuser to alter authentication
ERROR 6348: Must be superuser to create authentication
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 9375: Must have superuser privileges to set configuration
            parameter string at the user level
ERROR 9662: Cannot set resource pool: user string lacks privileges onstring
            resource pool string
ERROR 9959: Only database superusers can create external procedures
ERROR 9960: Only database superusers can drop external procedures
ERROR 9989: Must be superuser/dbadmin/sysmonitor to view other users
ERROR 10145: string "string" does not exist or the current user doesn't have
             access to it
ERROR 10310: Only superuser can debug a query
ERROR 10468: Must be superuser or have the UDXDEVELOPER role to create
             library
ERROR 10469: Must be superuser or have the UDXDEVELOPER role to drop
             library
ERROR 10514: Insufficient privileges on string; usage privliges needed
ERROR 10517: Must be superuser to execute ALTER PROCEDURE ... OWNER
ERROR 10554: Must be string to alter access policy
ERROR 10555: Must be string to copy access policy
ERROR 10556: Must be string to create access policy
ERROR 10557: Must be string to drop access policy
ERROR 10558: Only superusers or the owner of both tables can swap
             partitions with access policies
ERROR 10559: Only superusers or the source table owner can copy/move
             partitions with access policies

Notice messages

NOTICE 3583: Insufficient privileges on string

Warning messages

WARNING 5149: Unable to set role "string"
WARNING 5818: Deployment script will not be generated since the user
              does not have appropriate permissions to write to [string]
WARNING 5820: Design script will not be generated since the user does
              not have appropriate permissions to write to [string]

Note

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