The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Newsgroups: comp.databases.oracle.server
From: "newbie" <rjngh2...@gmail.com>
Date: 12 Jul 2006 10:20:35 -0700
Local: Wed 12 July 2006 18:20
Subject: insufficient priviliges
I have a schema called 'abc'
I do not know the password for the user 'abc' I know the password for the user 'sys' and user 'system' I tried the following when logged in as user 'sys' as sysdba and user select * from abc.pqr where 'pqr' is a table in schema 'abc' I get the result However If I create another user 'test' and try the following ORA-00942: table or view does not exist I tried the following when I am logged in as user 'sys' as sysdba or grant select on abc.pqr to test; The following is the error message ORA-01031: insufficient privileges How do I resolve this...Please help You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||