privileged users on Directory Objects

#1

Hi all,
how can I check the users that have privileges on a certain Directory
(object) ?

thanks,
pedro

#2

On May 24, 4:41 pm, Pedro Lopes <pedro.lo... (AT) netvisao (DOT) pt> wrote:

Quote:

Hi all,
how can I check the users that have privileges on a certain Directory
(object) ?

thanks,
pedro

This will give both users and roles:

SELECT grantee
FROM dba_tab_privs
WHERE table_name = <directory_name>

#3

On 24 May 2007 13:59:45 -0700, Valentin Minzatu <valentinminzatu (AT) yahoo (DOT) com>
wrote:

Quote:

On May 24, 4:41 pm, Pedro Lopes <pedro.lo... (AT) netvisao (DOT) pt> wrote:
Hi all,
how can I check the users that have privileges on a certain Directory
(object) ?

thanks,
pedro

This will give both users and roles:

SELECT grantee
FROM dba_tab_privs
WHERE table_name = <directory_name

You'd need more filters on that, such as "OWNER = 'SYS'" (which owns directory
objects), and the READ and/or WRITE privileges (since you can have other
objects with the same name, but they'll have different privileges like SELECT).

--
Andy Hassall :: andy (AT) andyh (DOT) co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

#4

On May 25, 7:29 pm, Andy Hassall <a... (AT) andyh (DOT) co.uk> wrote:

Quote:

On 24 May 2007 13:59:45 -0700, Valentin Minzatu <valentinminz... (AT) yahoo (DOT) com
wrote:

On May 24, 4:41 pm, Pedro Lopes <pedro.lo... (AT) netvisao (DOT) pt> wrote:
Hi all,
how can I check the users that have privileges on a certain Directory
(object) ?

thanks,
pedro

This will give both users and roles:

SELECT grantee
FROM dba_tab_privs
WHERE table_name = <directory_name

You'd need more filters on that, such as "OWNER = 'SYS'" (which owns directory
objects), and the READ and/or WRITE privileges (since you can have other
objects with the same name, but they'll have different privileges like SELECT).

--
Andy Hassall :: a... (AT) andyh (DOT) co.uk ::http://www.andyh.co.ukhttp://www.and....co.uk/space:: disk and FTP usage analysis tool

Make sure you take a look at what the init file or pfile setting is
for utl_file_dir

#5

hpuxrac wrote:

Quote:

Make sure you take a look at what the init file or pfile setting is
for utl_file_dir

Unless working with an obsolete version of Oracle it is better to us
directory objects (www.psoug.org/reference/directories.html).
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

privileged users on Directory Objects

comp.databases.oracle.server comp.databases.oracle.server

privileged users on Directory Objects - 05-24-2007 , 03:41 PM

Re: privileged users on Directory Objects - 05-24-2007 , 03:59 PM

Re: privileged users on Directory Objects - 05-25-2007 , 06:29 PM

Re: privileged users on Directory Objects - 05-25-2007 , 06:33 PM

Re: privileged users on Directory Objects - 05-25-2007 , 07:24 PM