Re: Can't Grant "select"

A copy of this was sent to "Joe" <Dont_at_Send.Com> (if that email address didn't require changing) On Thu, 2 Dec 1999 11:20:55 -0000, you wrote:

>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
>

No one can grant on anothers table without having first been granted that privelege with the GRANT OPTION.

Eg: ORC must issue:

grant select on wv_in_call_data to SYS with grant option;

then, SYS can grant select on that table to others.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 02 1999 - 06:35:29 CST