Re: grant user access
От | mike g |
---|---|
Тема | Re: grant user access |
Дата | |
Msg-id | 1090125335.17480.11.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | grant user access (Tom Allison <tallison@tacocat.net>) |
Ответы |
Re: grant user access
|
Список | pgsql-general |
See http://www.postgresql.org/docs/7.4/static/sql-grant.html Looks like you need something like GRANT ALL SELECT, ... ON DATABASE foo To bar; The below syntax is for table / view level grants. Mike On Sat, 2004-07-17 at 20:38, Tom Allison wrote: > I'm stuck. > > How do I grant select, insert, delete, update rights to an entire database? > > I tried this: > > GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE foo TO bar; > > and it returns > ERROR: syntax error at or near "INSERT" at character 14 > > I'm just not getting it, it sure looks like I should be able to. > I'm logged in as postgres. > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-general по дате отправления: