Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #52642] Sat, 03 August 2002 06:23 Go to next message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
I am getting the ORA-01031: insufficient privileges errors while i am trying to GRANT SELECT to USER1 on USER2's tables. I am even unable to grant it as sys/system user. I also found that the priviliges to sys and system are default(nothing is unlike) as usual.

Can anybody give me the solution?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #52654 is a reply to message #52642] Mon, 05 August 2002 04:18 Go to previous message
ulli
Messages: 24
Registered: September 1999
Junior Member
hello,

you should be logged on as user2 to grant privs to user1.

regards
ulli

Report message to a moderator

Previous Topic: performance issue, pls help
Next Topic: ORA:01194 Corrupt datafile erro
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 09:15:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.