Explain auth/access/priv system??
От | philip@adhesivemedia.com (Philip Hallstrom) |
---|---|
Тема | Explain auth/access/priv system?? |
Дата | |
Msg-id | 200005231830.LAA71716@illiad.adhesivemedia.com обсуждение исходный текст |
Ответы |
Re: Explain auth/access/priv system??
|
Список | pgsql-general |
Hi - I'm new to postgres and have some questions regarding the authentication and access systems. I've got postgres installed and can connect from remote machines, but have some questions: - I cannot connect as the postgres user 'postgres' from remote machines? Why? - How is pg_shadow managed? Is it built from the pg_user table? If so, how do I clean it up (doing a "strings pg_shadow" shows users that no longer exist -- is that a problem?) - In the docs under "Database/Table Privileges" it says "TBD". Can someone fill me in a bit. For example, as 'postgres' I did "CREATE DATABSE foo". Then I created the user "foo". I would have thought that I would have had to grant some sort of access to user "foo" to database "foo", but as user "foo" I was able to create tables in database "foo". Why? - What do I need to do in order to allow multiple users the abililty to create tables in a single database? Thanks! -philip
В списке pgsql-general по дате отправления: