Can't Grant -Select- priviliges

From: Joe <Dont_at_Send.Com>
Date: Thu, 2 Dec 1999 11:22:56 -0000
Message-ID: <yHs14.199$E36.10631@news2-hme0>

Hi I wonder whether you can help me with a "granting" problem. I have the same problem when connecting as SYS or Internal

I issue the following command in SQL *Plus on Oracle 7.3

grant select on orc.VW_IN_CALL_DATA to public; It comes back with this message;

ORA-01031: insufficient privileges

I then run this command;

select * from session_privs;
It returns with a whole list, among them is; PRIVILEGE
GRANT ANY PRIVILEGE I issue this command;
select * from v$pwfile_users (to tell me what rights I have);

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                         TRUE  TRUE
SYS                                     TRUE  TRUE

Can you please help
Joe Received on Thu Dec 02 1999 - 05:22:56 CST