Hi!
We have JAVAMAIL schema in 10gr2 DB. This user has a DBA role.
We would like to revoke DBA role from this user and grant it only necessary privileges.
The user has a lot of java objects and it's main uses for sending mails from DB.
select object_type, count(*) from dba_objects
where owner='JAVAMAIL'
group by object_type ;
FUNCTION 6
INDEX 2
JAVA CLASS 257
JAVA RESOURCE 9
JAVA SOURCE 6
LOB 1
PACKAGE 1
PACKAGE BODY 1
PROCEDURE 4
TABLE 2
The main object of this schema is:
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED JAVAMAIL."SendMail" as import java.util.*;
import java.io.*;
import javax.mail.*;
import javax.mail.internet.*;
import javax.activation.*;
...
Please advise, how to remove DBA privilege safely.