Table of Contents

Search

  1. About the Data Vault Message Reference
  2. Data Definition Language Errors
  3. Data Vault Repository Service Exit Codes
  4. Load Balancer and Administration Errors
  5. Data Vault Repository Administration CLI Errors
  6. Data Vault SQL Tool Messages
  7. Data Vault Loader Messages

Data Vault Message Reference

Data Vault Message Reference

42502

42502

Insufficient privileges on schema
This message appears when a user attempts an ALTER TABLE, DROP TABLE, or DROP VIEW statement in the user's default schema, and the user does not own the schema, possess the OWNER privilege on it, or possess DBA privileges. This message also appears if a DROP DOMAIN or RENAME DOMAIN statement specifies a domain on which the user issuing the statement has no privileges.
In order to ALTER, DROP, or RENAME these database objects, the OWNER privilege on the schema containing the object must be granted by the schema owner or the DBA.

0 COMMENTS

We’d like to hear from you!