Google Mail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Message from discussion insufficient priviliges
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
 
From:
To:
Cc:
Follow-up To:
Add Cc | Add Follow-up to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers that you hear
 
newbie  
View profile   Translate to Translated (View Original)
 More options 12 July 2006, 18:20
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
'system' and user 'sys' (normal)

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
select * from abc.pqr it gives me the result

ORA-00942: table or view does not exist

I tried the following  when I am logged in as user 'sys' as sysdba or
sysoper or normal or user system

grant select on abc.pqr to test;

The following is the error message

ORA-01031: insufficient privileges

How do I resolve this...Please help


    Reply to author    Forward  
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.

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google