@Entity
@Table(name = "CONFIGURACAO", schema = "SEGURANCA")
@GenericGenerator(name = "CONFIGURACAO_SQ",strategy="increment")
public class Configuracao {

@Id
@GeneratedValue(generator = "CONFIGURACAO_SQ")
@Column(name = "ID")
private Long id;

Like above hibernate doens`t honor schema name , generating query like

select max(id) from CONFIGURACAO

instead

select max(id) from SEGURANCA.CONFIGURACAO