X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 32A8F9DC94B for ; Wed, 1 Mar 2006 00:20:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87987-04 for ; Wed, 1 Mar 2006 00:20:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 1F3A79DC946 for ; Wed, 1 Mar 2006 00:20:24 -0400 (AST) Received: by zproxy.gmail.com with SMTP id v1so47391nzb for ; Tue, 28 Feb 2006 20:20:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=s2RHWv+SLzZbIMmK6jVMEjwWyx//q5PZwhmgAOr0ph7+BzHleOo4CP16nnXKlNkaPXp+yPVY22Fdk9r6AiEXKy8dsNgM8GInb69ql3vEP6kXQ5jjKAkAryx+MZsaVKmQIT1ylBvxd4i8vojy+YyRMMaVzIJEIToyTIqyd2wCZd4= Received: by 10.65.100.16 with SMTP id c16mr712640qbm; Tue, 28 Feb 2006 20:20:24 -0800 (PST) Received: by 10.65.98.13 with HTTP; Tue, 28 Feb 2006 20:20:24 -0800 (PST) Message-ID: Date: Wed, 1 Mar 2006 09:50:24 +0530 From: "AKHILESH GUPTA" To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: regarding grant option MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14075_24766529.1141186824312" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.803 required=5 tests=[AWL=-0.143, HTML_10_20=0.945, HTML_MESSAGE=0.001] X-Spam-Score: 0.803 X-Spam-Level: X-Archive-Number: 200603/2 X-Sequence-Number: 91867 ------=_Part_14075_24766529.1141186824312 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi all.... this is akhilesh from india.i just want to ask one thing regarding grant operation?? i am using pgsql 8.0 on ubuntu 5.10 linux. 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 to ; GRANT :->> grant all ON DATABASE to ; 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. here i have to grant permissions to that user individually for each and every table by using: :->> grant ALL ON to ; GRANT and all the permissions are granted to that user for that particular table. i want same results for the entire database................. plz help me it's urgent -- Thanks & Regards, Akhilesh DAV Institute of Management Faridabad(Haryana) GSM:-(+919891606064) (+911744293789) "FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME" ------=_Part_14075_24766529.1141186824312 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi all....
this is akhilesh from india.i just want to ask one thing regarding grant op= eration??
i am using pgsql 8.0 on ubuntu 5.10 linux.
just tell me the procedure that how can i grant all permissions for a datab= ase to any of the other user???
i am using :-
:->> grant all privileges on database <db_name> to <user_nam= e>;
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.
here i have to grant permissions to that user individually for each and eve= ry 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.=

i want same results for the entire database.................
plz help me it's urgent

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

"FAILURES CAN BE= FORGIVEN BUT AIMING LOW IS A CRIME" ------=_Part_14075_24766529.1141186824312--