On Mon, 2011-08-08 at 11:42 +0530, Adarsh Sharma wrote:
> Guillaume Lelarge wrote:
> > On Mon, 2011-08-08 at 10:28 +0530, Adarsh Sharma wrote:
> >
> >> Dear all,
> >>
> >> Today I researched on giving privileges in Postgres databases. I have 4
> >> databases and near about 150 tables, 50-60 seq
Guillaume Lelarge wrote:
On Mon, 2011-08-08 at 10:28 +0530, Adarsh Sharma wrote:
Dear all,
Today I researched on giving privileges in Postgres databases. I have 4
databases and near about 150 tables, 50-60 sequences and also some views
in it.
I want to give privileges to a new user in al
On Mon, 2011-08-08 at 10:28 +0530, Adarsh Sharma wrote:
> Dear all,
>
> Today I researched on giving privileges in Postgres databases. I have 4
> databases and near about 150 tables, 50-60 sequences and also some views
> in it.
>
> I want to give privileges to a new user in all these objects. I
On 08/07/11 9:58 PM, Adarsh Sharma wrote:
Dear all,
Today I researched on giving privileges in Postgres databases. I have
4 databases and near about 150 tables, 50-60 sequences and also some
views in it.
I want to give privileges to a new user in all these objects. I
created a function for
Dear all,
Today I researched on giving privileges in Postgres databases. I have 4
databases and near about 150 tables, 50-60 sequences and also some views
in it.
I want to give privileges to a new user in all these objects. I created
a function for that but don't know how to give privileges
Ah - my apologies, I realized you will need to add a function for exec
(which may also require plpgsql language added to your database).
On Tue, May 17, 2011 at 12:00 AM, Christopher Opena
wrote:
> Per 8.0 documentation, in order to ALTER a table (including rename), you
> have to be the owner of
2011/5/17 Adarsh Sharma :
> Dear all,
>
> Today I grant a user all privileges to all tables in a database by
>
> grant all privileges on svo_data_social to neha ; grant all
> privileges on svo_phrases to neha ;
> .. . .
> .
> ...
>
> Now i find it very uncomfort to grant
Per 8.0 documentation, in order to ALTER a table (including rename), you
have to be the owner of a table:
"You must own the table to use ALTER TABLE; except for ALTER TABLE OWNER,
which may only be executed by a superuser."
http://www.postgresql.org/docs/8.0/static/sql-altertable.html
If you want
Dear all,
Today I grant a user all privileges to all tables in a database by
grant all privileges on svo_data_social to neha ;
grant all privileges on svo_phrases to neha ;
.. . .
.
...
Now i find it very uncomfort to grant privileges one by one table.
Is there a
Marc Balmer <[EMAIL PROTECTED]> writes:
> I have two login roles, user_A and admin_A, and a group role, group_A.
> user_A is member of group_A
> I create a table t_data, owned by admin_A
> I create a view v_data, owned by admin_A
> Now I grant SELECT privilege on view v_data to group_A
> I would
I am having a hard time here with PostgreSQL 8.2.4... What I want to do
is rather simple:
I have two login roles, user_A and admin_A, and a group role, group_A.
user_A is member of group_A
I create a table t_data, owned by admin_A
I create a view v_data, owned by admin_A
Now I grant SELECT privi
at Saint-Joseph University
Lebanon
- Original Message -
From:
Nageshwar Rao
To: [EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 7:36
AM
Subject: [GENERAL] granting
privileges
How
to grant privileges to all objects( tables,sequences
etc) in specific
How to grant privileges to all objects( tables,sequences etc) in specific schema, I mean I want
to give users select,insert,delete and update to all objects in the schema in
one sql statement.I know
Grant select,insert,update,delete
on table_name to user_name. But this is
for individu
Hi,
I'm implementing a database with very 'restrictive'
privileges. However I've hit a dead end trying to
solve one issue.
When GRANTing execute to a plpgsql function it
appears to run with the priviledge of the user and
NOT with the priviledges of the owner of the function.
This is causing a p
I have created a group in postgres by inserting a group name into
pg_group as suggested in the on-line documentation. I then add a user to
this group using the appropriate create user syntax. Finally, I grant
privileges to the group for a specific table. The system responds
affirmatively up this
15 matches
Mail list logo
