RE: Privileges on directory object are failing
- From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
- To: "David Sharples" <davidsharples@xxxxxxxxx>
- Date: Thu, 14 Jul 2005 17:16:34 -0400
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@xxxxxxxxx]
Sent: Jueves, 14 de Julio de 2005 04:11 p.m.
To: Aragon, Gabriel (GE Commercial Finance)
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxx> 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" ;
--
//www.freelists.org/webpage/oracle-l
Other related posts:
