![]() ![]() Simpeg | postgres | UTF8 | English_United States.1252 | English_United States.1252 | Postgres | postgres | UTF8 | English_United States.1252 | English_United States.1252 | Mydb | admin | UTF8 | English_United States.1252 | English_United States.1252 | Name | Owner | Encoding | Collate | Ctype | Access privileges Last but not least, list the database to check whether the new created database exist or not by typing the following query : ![]() In this context, it is the user with the name of ‘admin’ as follows ~]# psql -Uadmin postgresįinally, create the database by executing the following query : Next, connect to the PostgreSQL command console once more using the first user. Soon after, execute the command to add the createdb role as follows : Login first as postgres or as a superuser account by typing the following command ~]#psql -Upostgres So, add a new role attribute to the user. So, as in the above output, it is very clear that the user ‘admin’ does not have any role attributes at all. Postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | The query pattern for altering the user’s permission exist as follows : Just execute the command to add a role for creating database. Since there is a slight connection with the permission issue, below are steps to solve the problem :įirst of all, just check the permission of the user from the PostgreSQL command console by accessing the PostgreSQL command console as follows ~]# psql -Uadmin postgresĪfter that, type the follwoing command to change the permission of the user. As the error message is indicating a permission issue, there might be a connection with the role of the user executing the command. So, there must be a solution to solve the problem above. ![]() Sadly, but it is true, the command for creating a new database does not work as usual. Create a new database in the PostgreSQL command console by executing the following query :ĮRROR: permission denied to create database ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |