import java.sql.*;
import java.util.*;
import oracle.jdbc.*;
public class ConnectAsSysSample {
public ConnectAsSysSample( ) throws SQLException {
DriverManager.registerDriver( new OracleDriver( ) );
}
public static void main( String[] args ) throws SQLException {
ConnectAsSysSample sample = new ConnectAsSysSample( );
sample.getUserRoles( );
}
public void getUserRoles( ) throws SQLException {
Connection conn = this.getConnection( );
Statement stmt = conn.createStatement( );
ResultSet rset = stmt.executeQuery( " SELECT UserName, Granted_Role, Admin_Option FROM USER_ROLE_PRIVS " );
System.out.println( "UserName Granted Role Admin Option ");
while ( rset.next( ) )
System.out.println( rset.getString( 1 ) + " " + rset.getString( 2 ) + " " + rset.getString( 3 ) );
rset.close( );
stmt.close( );
conn.close( );
}
public Connection getConnection( ) throws SQLException {
String jdbcurl = "jdbc:oracle:thin:@localhost:1521:ias904";
Properties props = new Properties( );
props.setProperty( OracleDriver.logon_as_internal_str , "sysdba" );
props.setProperty( OracleDriver.user_string , "sys" );
props.setProperty( OracleDriver.password_string , "sys" );
return DriverManager.getConnection( jdbcurl, props );
}
}