I create this connected to postgres database:
create role prueba_role with nosuperuser nocreatedb nocreaterole nologin
noinherit;
revoke all on database prueba_roles from prueba_role cascade;
revoke create on database prueba_roles from prueba_role cascade;
create user sidar with password 'sidar' login in role prueba_role;
Then connect to prueba_roles database with user sidar.
I guess that with these configuration the user cannot create tables, but I
can do it.
How to reestrict users to one database access and how to allow only SELECT
permited?
_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.