[错误:架构公共位置的权限被拒绝:14]

我正在使用postgresql 15,并尝试运行以下命令:

grant all privileges on database my_database to my_database_user;
grant all privileges on all tables in schema public to my_database_user;
grant all privileges on all sequences in schema public to my_database_user;
grant all privileges on all functions in schema public to my_database_user;

但当我跑步时:

php artisan migrate --seed 

我得到:

SQLSTATE[42501]:权限不足:7错误:在字符14处拒绝架构公共的权限(SQL:创建表“migrations”(“id”串行主键不为空,“migration”varchar(255)不为空、“batch”整数不为空)

我错过了什么?

我确实确保.env具有正确的凭据:

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=my_database
DB_USERNAME=my_database_user
DB_PASSWORD=password

检查我是否做到了:

postgres=# \du my_database_user
            List of roles
  Role name  | Attributes | Member of 
-------------+------------+-----------
 my_database_user |            | {}

以及:

postgres=# SELECT * FROM pg_roles;
          rolname          | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls | rolconfig |  oid  
---------------------------+----------+------------+---------------+-------------+-------------+----------------+--------------+-------------+---------------+--------------+-----------+-------
 my_database_user               | f        | t          | f             | f           | t           | f              |           -1 | ********    |               | f            |           | 16389