Postgres Utenti: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
|||
Riga 8: | Riga 8: | ||
==utenti sola lettura== |
==utenti sola lettura== |
||
create role ciccio_pasticcio with login encrypted password 'XXXYYYYZZZZZ'; |
create role ciccio_pasticcio with login encrypted password 'XXXYYYYZZZZZ'; |
||
create group pasticcio_ro; |
create group pasticcio_ro; |
||
alter group pasticcio_ro add user ciccio_pasticcio; |
alter group pasticcio_ro add user ciccio_pasticcio; |
||
grant connect on database pasticci_db to pasticcio_ro; |
grant connect on database pasticci_db to pasticcio_ro; |
||
grant usage on schema pasticci_schema to pasticcio_ro; |
grant usage on schema pasticci_schema to pasticcio_ro; |
||
grant select on all tables in schema pasticci_schema to pasticcio_ro; |
grant select on all tables in schema pasticci_schema to pasticcio_ro; |
||
Versione delle 10:54, 9 mar 2022
Super User
create role pgadmin with encrypted password 'XXXYYYYZZZZZ'; alter role pgadmin with login; grant all privileges on database postgres to pgadmin; alter role pgadmin with createdb; alter role pgadmin with createrole; alter role pgadmin with superuser;
utenti sola lettura
create role ciccio_pasticcio with login encrypted password 'XXXYYYYZZZZZ'; create group pasticcio_ro; alter group pasticcio_ro add user ciccio_pasticcio; grant connect on database pasticci_db to pasticcio_ro; grant usage on schema pasticci_schema to pasticcio_ro; grant select on all tables in schema pasticci_schema to pasticcio_ro;