[Solved] Add user to Db

[bee1]

Hi,

I have just created a new db for my account called 'bee1_hives'. Can you please...

1. Open access for the new user as well 'bee1_hive_user' for insert and read permissions AND

2. Open access so I can remote into it with PGAdmin please?

 

Thank you!

[bee1]

Also, once the above has been granted, will I be able to create a table in the database?

[Krydos]

48 minutes ago, bee1 said:

Open access so I can remote into it with PGAdmin please?

Remote access enabled.

48 minutes ago, bee1 said:

Open access for the new user as well 'bee1_hive_user' for insert and read permissions AND

45 minutes ago, bee1 said:

Also, once the above has been granted, will I be able to create a table in the database?

You don't have to request this on a database created through Plesk. We had permission issues when transferring databases from cPanel to Plesk, but I tested out a new database created through Plesk and it all worked just fine for me.

root@tommy2 [/home/krydos]# psql --dbname=krydos_testdb --username=krydos_testuser
Password for user krydos_testuser:
psql (13.8)
Type "help" for help.

krydos_testdb=> \dt+
Did not find any relations.
krydos_testdb=> create table test_table (id serial primary key, username varchar(255) not null);
CREATE TABLE
krydos_testdb=> \dt+
                                  List of relations
 Schema |    Name    | Type  |      Owner      | Persistence |  Size   | Description
--------+------------+-------+-----------------+-------------+---------+-------------
 public | test_table | table | krydos_testuser | permanent   | 0 bytes |
(1 row)

krydos_testdb=> insert into test_table (username) values ('Krydos');
INSERT 0 1
krydos_testdb=> select * from test_table;
 id | username
----+----------
  1 | Krydos
(1 row)

 

[bee1]

Thank you, this is working now!