I added the user
Then, through the PgAdminIII GUI I added the database
mydatabase and I restored from a backup file. So, the owner of
mydatabase is the "administator" user
Then, I tried to give to
myuser all the rights to access and modify the
What I did is logging to psql ad administrator:
psql -d template1 -U postgres
and then I run this query:
GRANT ALL PRIVILEGES ON DATABASE mydatabase TO myuser
Now, I can use
myuser to log, but if a try to do a simple query I get this error:
ERROR: permission denied for relation table_name
Am I missing something? Can you help me solvign that?
Thank you very much.