| From: | Niral Trivedi <niral(dot)trivedi(at)insage(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | User Privileges |
| Date: | 2000-12-26 16:55:23 |
| Message-ID: | 328DC4EC2C9B74428D8DAED1931285BF10D987@FLAN-EXCH01.corp.insage.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
All,
How can you grant privileges to a user to all tables in database?
For example I have 5 tables in database A. And now I want to give
SELECT/UPDATE/INSERT privileges to a user to all 5 tables. But according to
documentation, I have to execute 'GRANT' query 3 times(for
select/update/insert) per table. meaning total of 15 times!!!!
Is there any way I can do that in just one shot?
Basically I want to give user privileges to all tables in databse at once.
Like we can do in MySQL by adding a user in 'db' and 'user' table.
Is it possible in PostgreSQL? How?
Thanks in advance..
Niral
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niral Trivedi | 2000-12-26 17:36:29 | RE: User Privileges |
| Previous Message | Anand Raman | 2000-12-26 15:54:37 | Re: How I can join between the other database's tables? |