Privileges on directory object are failing

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Thu, 14 Jul 2005 17:07:41 -0400
Message-ID: <84B673E70D068347A2F54A51457E5C270836FA97@CINMLVEM05.e2k.ad.ge.com>

Hi list, oracle 9.2.0.6.0, SunOS 5.8 sun4u sparc SUNW,Sun-Fire  

this is making me crazy, I have 2 directories created:  

CREATE OR REPLACE DIRECTORY "DIR_NB" AS

'-------------------NB';
 

CREATE OR REPLACE DIRECTORY "DIR_ND" AS

'-------------------ND';
 

I have 2 users:  

CREATE USER "AC" PROFILE "DEFAULT"
    IDENTIFIED BY "AC" DEFAULT TABLESPACE "---"     TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK; GRANT CREATE ANY TABLE TO "AC";
GRANT CREATE SNAPSHOT TO "AC";
GRANT UNLIMITED TABLESPACE TO "AC";
GRANT EXECUTE ON "SYS"."DBMS_SYSTEM" TO "AC"; GRANT "CONNECT" TO "AC";
GRANT "RESOURCE" TO "AC";

---

CREATE USER "NV" PROFILE "DEFAULT"
    IDENTIFIED BY "NV" DEFAULT TABLESPACE "---"     TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK; GRANT CREATE ANY TABLE TO "NV";
GRANT UNLIMITED TABLESPACE TO "NV";
GRANT EXECUTE ON "SYS"."DBMS_SYSTEM" TO "NV"; GRANT "CONNECT" TO "NV";
GRANT "RESOURCE" TO "NV"; and privs for dirs are:  

drwxrwxrwx 96 Jul 14 15:24 ND
drwxrwxrwx 96 Jun 23 13:49 NB  

but when I try to assing privs:  

        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" ;         Grant succeeded.

Write privilege on directories works for user NV but fails for user AC, what am I missing here???? No luck on metalink or google.  

TIA
Gabriel

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

Received on Thu Jul 14 2005 - 16:09:37 CDT