Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi,I am a new user with PostgreSQL, I came from MySQL and I am experiencing some issues with roles and privileges.I have created a DB,user and grant privilege on this DB to this user. How could I check what is the privileges/permissions for this user?Transcript:postgres=# create database test;CREATE DATABASEpostgres=# create user test with password 'test';CREATE ROLEpostgres=# grant all privileges on database test to test;GRANTpostgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/postgres+ | | | | | test=CTc/postgres test1 | test1 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/test1 + | | | | | test1=CTc/test1(5 rows)With "\l" command It's no clear. Finally, I don't find some command like "show grants for..." in MySQL. Regards.Bryan
Hi,
I am a new user with PostgreSQL, I came from MySQL and I am experiencing some issues with roles and privileges.
I have created a DB,user and grant privilege on this DB to this user. How could I check what is the privileges/permissions for this user?
Transcript:
With "\l" command It's no clear.
Finally, I don't find some command like "show grants for..." in MySQL.
Regards.
Bryan
В списке pgsql-general по дате отправления: