Privileges on directory object are failing 2005-07-14 - By Aragon, Gabriel (GE Commercial Finance)
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@(protected)]
Sent: Jueves, 14 de Julio de 2005 04:11 p.m.
To: Aragon, Gabriel (GE Commercial Finance)
Cc: oracle-l@(protected)
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@(protected)> 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 (See ORA-00942.ora-code.com): 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 (See ORA-00942.ora-code.com): 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
|
|
