regarding grant option

On Wed, Mar 01, 2006 at 09:50:24AM +0530, AKHILESH GUPTA wrote:

just tell me the procedure that how can i grant all permissions for a
database to any of the other user???
i am using :-
:->> grant all privileges on database <db_name> to <user_name>;
GRANT
:->> grant all ON DATABASE <db_name> to <user_name>;
GRANT

and the query executes succesfully.
but at the other user end, she is not able to access the database given in
the above query.

Can the user connect to the database at all? Is she getting an
error message? If so, what's the error and at what point in the
connection is she getting it? What did she do immediately prior
to getting the error? Do the server logs contain any error messages?
If so, what are they?

If the user can't even connect then the problem is likely with
pg_hba.conf. See "Client Authentication" in the documentation for
more information:

http://www.postgresql.org/docs/8.0/interactive/client-authentication.html

--
Michael Fuhr

AKHILESH GUPTA wrote:

here i have to grant permissions to that user individually for each and
every table by using:
:->> grant ALL ON <tab_name> to <user_name>;
GRANT
and all the permissions are granted to that user for that particular table.

Yes. If you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

thank you very much sir for your valuable suggestion,
but i am talking about direct database query...........!

On 3/1/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:

AKHILESH GUPTA wrote:

here i have to grant permissions to that user individually for each and
every table by using:
:->> grant ALL ON <tab_name> to <user_name>;
GRANT
and all the permissions are granted to that user for that particular

table.

Yes. If you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.

--
Alvaro Herrera
http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

AKHILESH GUPTA wrote:

thank you very much sir for your valuable suggestion,
but i am talking about direct database query...........!

There is none that can help you here, short of making a function in
PL/pgSQL or other language ...

On 3/1/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:

AKHILESH GUPTA wrote:

here i have to grant permissions to that user individually for each and
every table by using:
:->> grant ALL ON <tab_name> to <user_name>;
GRANT
and all the permissions are granted to that user for that particular

table.

Yes. If you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Though, it is pretty easy to do something like:

select 'GRANT ALL ON ' || table_name || ' TO public;' from
information_schema.tables where table_schema='blah';

You can feed the output of that to psql, ei:

psql -qc "select 'GRANT ALL ON ' || table_name || ' TO public;' from
information_schema.tables where table_schema='blah'" | psql

On Wed, Mar 01, 2006 at 12:00:16PM -0300, Alvaro Herrera wrote:

AKHILESH GUPTA wrote:

thank you very much sir for your valuable suggestion,
but i am talking about direct database query...........!

There is none that can help you here, short of making a function in
PL/pgSQL or other language ...

On 3/1/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:

AKHILESH GUPTA wrote:

here i have to grant permissions to that user individually for each and
every table by using:
:->> grant ALL ON <tab_name> to <user_name>;
GRANT
and all the permissions are granted to that user for that particular

table.

Yes. If you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461