bee1 Posted October 29, 2022 Share Posted October 29, 2022 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! Quote Link to comment Share on other sites More sharing options...
bee1 Posted October 29, 2022 Author Share Posted October 29, 2022 Also, once the above has been granted, will I be able to create a table in the database? Quote Link to comment Share on other sites More sharing options...
Krydos Posted October 29, 2022 Share Posted October 29, 2022 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) Quote Link to comment Share on other sites More sharing options...
bee1 Posted October 31, 2022 Author Share Posted October 31, 2022 Thank you, this is working now! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.