Re: Simple commands don't work

Check in your pg_hba.conf file.
http://www.postgresql.org/docs/9.1/interactive/auth-pg-hba-conf.html

If you are working on the server itself, pg_hba.conf may be letting you in
without passwords. You'll see a line like 'host all all 127.0.0.1 trust'.

On Mon, Jun 16, 2014 at 10:45 AM, Larry Martell <larry(dot)martell(at)gmail(dot)com>
wrote:

> Hello-
>
> I am new to Postgres, but I am very experienced with Sybase, Oracle,
> and MySQL. I am trying to use some simple commands, but they do not
> seem to work.
>
> First I wanted to give myself a password. I read in the online docs
> the command was this:
>
> phis=> alter user larry set password = 'XXXX';
> ERROR: unrecognized configuration parameter "password"
>
> Then I read somewhere else it is:
>
> phis=> ALTER USER larry WITH PASSWORD 'XXXX';
> ALTER ROLE
>
> But then it still let me log in without one.
>
> Then I checked with pgAdmin and it showed I did not have any password.
> I set one there, but it still lets me login without one.
>
> Then I went to do a select from a table, and I got permission denied.
> But the table is in a schema (the name is "public") that is set for
> "GRANT ALL TO ALL"
>
> According to the docs this would be the command to grant access to all
> tables:
>
> phis=> grant select on all tables in public to larry;
> ERROR: syntax error at or near "public"
>
> But it doesn't like that. The I found this:
>
> phis=> grant ALL PRIVILEGES ON DATABASE phis to larry;
> WARNING: no privileges were granted for "phis"
>
> From pgAdmin I was able to grant myself select access, but why don't
> the command line commands work?
>
>
> Thanks!
> -larry
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>