Oracle DBA, How To, Error, Cause and Action

ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user

ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user


Cause:


Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges



Action:


Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on object, or non-SYS user should connect as SYS

No comments:

Post a Comment

Thanks for your comment.