grant all the database object automatically
| От | Akbar |
|---|---|
| Тема | grant all the database object automatically |
| Дата | |
| Msg-id | 1106215876.10828.9.camel@tux.akbarhome обсуждение исходный текст |
| Ответы |
Re: grant all the database object automatically
Re: grant all the database object automatically |
| Список | pgsql-novice |
How do I give all database object to another user so that user can do everything he wants? ALTER DATABASE blabla OWNER TO another_user; does not give what I want because that another user still does not have right to manipulate table inside database. Since there is no ALTER TABLE * blabla command ( see the * / wild card sign ), I alter table one by one so that another user can do some operation on those table..... Is there any easier way to do this.....? Ok, after this, what should I do to give database objects fully to another user beside tables?? Should I alter function, view??? Is there any tool or command to give all database objects to another user automatically?
В списке pgsql-novice по дате отправления: