Re: Can't Grant -Select- priviliges

Thanks for that Neil

I'm using the Oracle Schema Manager and.. even when logging on as System, I can't see my view from SQL *Plus but I can go into Oracle Schema Manager as user System and change the View. Strange. I also notice that User ORC has as Authentication = External, not password

I'm totally confused.

I must have pressed something good because I can now access my View from public.

Joe

> The grantor must own the object, or have been granted the required
privilege
> (select) on the object with the admin option.
>
> Therefor, only user orc can grant select to public, or, user orc will have
> to grant select on VW_IN_CALL_DATA to sys with ADMIN option, so that sys
> can then grant select on that object.
>
> HTH
>
> NeilC
>
> Joe wrote in message ...
> >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 - 11:46:44 CST