RE: Privileges on directory object are failing

I think I have too much hours on me.. silly me..

tks David.. I dont know how I missed that..

-----Original Message-----
From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: Jueves, 14 de Julio de 2005 04:11 p.m. To: Aragon, Gabriel (GE Commercial Finance) Cc: oracle-l_at_freelists.org
Subject: Re: Privileges on directory object are failing

you are missig the directory keyword on the statements with the errors

On 7/14/05, Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com> wrote:
>
> SQL> GRANT READ ON DIRECTORY "SYS"."DIR_NB" TO "AC";
>
> Grant succeeded.
>
> SQL> GRANT READ ON DIRECTORY "SYS"."DIR_ND" TO "AC";
>
> Grant succeeded.
>
> SQL> GRANT WRITE ON "SYS"."DIR_NB" TO "AC";
>
> GRANT WRITE ON "SYS"."DIR_NB" TO "AC"
>
> *
>
> ERROR at line 1:
>
> ORA-00942: table or view does not exist
>
>
>
> SQL> GRANT WRITE ON "SYS"."DIR_ND" TO "AC";
>
> GRANT WRITE ON "SYS"."DIR_ND" TO "AC"
>
> *
>
> ERROR at line 1:
>
> ORA-00942: table or view does not exist
>
>
>
> SQL> GRANT WRITE ON DIRECTORY "DIR_NB" TO "NV";
>
> Grant succeeded.
>
> SQL> GRANT READ ON DIRECTORY "DIR_NB" TO "NV" ;
>
> Grant succeeded.
>
>
>
> SQL> GRANT WRITE ON DIRECTORY "DIR_ND" TO "NV";
>
> Grant succeeded.
>
> SQL> GRANT READ ON DIRECTORY "DIR_ND" TO "NV" ;

--
http://www.freelists.org/webpage/oracle-l