Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #39170] Sun, 23 June 2002 07:24 Go to next message
Menny
Messages: 1
Registered: June 2002
Junior Member
Hi everyone
I'm trying to update user_tables and I'm getting an error.Here is the code :

SQL> update user_tables
2 set TABLE_LOCK='DISABLED'
3 where table_name='EMP1';
update user_tables
*
ERROR at line 1:
ORA-01031: insufficient privileges

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #39171 is a reply to message #39170] Sun, 23 June 2002 14:22 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No user is allowed / advised to manipulate any system table or view(except a very few)!
like user_*, dba_* etc.

Report message to a moderator

Previous Topic: NULL column value loading in sql loader
Next Topic: autocommit
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 10:46:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.