how to check file permissions

Posted on 2011-10-31
Last Modified: 2012-05-12
Hello All,

I granted the file permission to a user using

exec dbms_java.grant_permission( 'TESTUSER', '', '/filers/ dle/reader.csv','read');

Is there a query exists I can use to check if the permissions has been assigned to this user on this file.
Question by:dojjol
    LVL 73

    Accepted Solution

    look in dba_java_policy
    LVL 73

    Expert Comment


     WHERE grantee = 'TESTUSER' AND type_name = '' AND action = 'read'
    LVL 23

    Assisted Solution

    select * from USER_JAVA_POLICY where grantee_name = 'TESTUSER';

    Author Closing Comment

    Thanks sdstuber and OP Zaharin

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    PL/SQL Group by 2 34
    Oracle SQL Query Syntax 6 71
    Add 0 to end of Number 21 60
    adding % symbol to a percentage - oracle query 16 25
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to recover a database from a user managed backup

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now