org.postgresql.util.PSQLException while connecting database from spring boot application

Question

I have PostgreSQL database form there I have created database and user using below commands.

create database webreporting;   
create user csr with password 'csrtest12!@';    
grant all on  database webreporting to csr;    
GRANT ALL PRIVILEGES ON ALL TABLES
    IN SCHEMA public to csr;    
GRANT ALL PRIVILEGES ON ALL TABLES IN
    SCHEMA public TO csr;    
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN
    SCHEMA public TO csr;

I am trying connect this database from springboot application. Spring boot application is started successfully but while executing the query from application it's throwing exception like below

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [Delete from facts where customer_id=?]; nested exception is
org.postgresql.util.PSQLException: ERROR: permission denied for table facts.

Application.properties file is:

spring.datasource.driver-class-name=org.postgresql.Driver   
spring.datasource.url=jdbc:postgresql://localhost:5432/webreporting 
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect   
spring.datasource.username=csr   
spring.datasource.password=csrtest12!@

I am not sure why I am getting permission denied exception.

Has your user login privileges? Try ALTER ROLE <username> WITH LOGIN; — Ortwin Angermeier
– Ortwin Angermeier, Commented Aug 28, 2019 at 23:13

dominikbrandon · Accepted Answer · 2019-08-28 17:51:31Z

2

You're probably missing permissions on schema. Try running below command:

GRANT USAGE ON SCHEMA public TO csr;

answered Aug 28, 2019 at 17:51

dominikbrandon

4284 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dominikbrandon Over a year ago

Is that table already created or you're expecting it to be created on startup?

madhusudhan Over a year ago

its startup after this i want to create table

dominikbrandon Over a year ago

If you want your JPA entities to be created on startup, you need to set ddl-auto property in Spring configuration - docs. Also, try to set the schema of your entity to public.

Collectives™ on Stack Overflow

org.postgresql.util.PSQLException while connecting database from spring boot application

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related