how to check file permissions

Hello All,

I granted the file permission to a user using

exec dbms_java.grant_permission( 'TESTUSER', 'SYS:java.io.FilePermission', '/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.
dojjolAsked:
Who is Participating?
 
sdstuberCommented:
look in dba_java_policy
0
 
sdstuberCommented:

 WHERE grantee = 'TESTUSER' AND type_name = 'java.io.FilePermission' AND action = 'read'
0
 
OP_ZaharinCommented:
select * from USER_JAVA_POLICY where grantee_name = 'TESTUSER';
0
 
dojjolAuthor Commented:
Thanks sdstuber and OP Zaharin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.