-

Para criar um DIRECTORY no Oracle utilize o seguinte comando

Create directory FIEA as 'caminho' onde:


No linux:
/home/fiea

No Windows:

'c:\fiea';

Atribuindo permissão de leitura ou escrita em um diretório:

--grant read
GRANT read on DIRECTORY dir_name to user_name;

--grant write permission
GRANT write on DIRECTORY dir_name to user_name;

-- grant both
GRANT READ,WRITE ON DIRECTORY dir_Name TO user_Name;

Exemplo: GRANT READ, WRITE ON DIRECTORY FIEA TO DBAPS;


Removendo Permissão de um diretório

-- revoke read permission
REVOKE read on DIRECTORY dir_name FROM User_Name;
-- revoke write permission
REVOKE write on DIRECTORY dir_name FROM User_Name;
-- revoke both
REVOKE read,write on Directory dir_name from user_name;

Leave a Comment

Your email address will not be published.

You may use these HTML tags and attributes: <a href=""> <abbr> <acronym> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Send a Message