Jump to content

[Solved] Add user to Db


bee1

Recommended Posts

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!

Link to comment
Share on other sites

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)

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...