Mead
To: Eduardo Sá dos Reis
Cc: pgsql-admin@postgresql.org
Sent: Monday, October 26, 2009 10:04 AM
Subject: Re: [ADMIN] Permissions to schema
2009/10/26 Eduardo Sá dos Reis eduardor...@pjf.mg.gov.br
Hi,
I have the structure on Postgre:
database: dbGlobal
schema1
Hi,
I have the structure on Postgre:
database: dbGlobal
schema1: sch_sist1 owner sch_sist1: john
schema2 sch_sist2 owner sch_sist2: mary
I' m using pgAdmin III.
Is there a way to avoid the mary to access the schema sch_sist1 ?
I don't want that mary see/access
2009/10/26 Eduardo Sá dos Reis eduardor...@pjf.mg.gov.br
Hi,
I have the structure on Postgre:
*database*: dbGlobal
*schema1:* sch_sist1 *owner *sch_sist1: john
*schema2 *sch_sist2 *owner *sch_sist2: mary
I' m using pgAdmin III.
Is there a way to avoid
I have a bunch of tables which have child table that are partitions (several
of them). Is there a way I can create a user with SELECT permissions on the
parent without having to individually give the same permission on all child
tables ? Every time I create new partitions..I have to explicitly
On Wed, Jun 17, 2009 at 3:55 PM, Anj Adufotogra...@gmail.com wrote:
I have a bunch of tables which have child table that are partitions (several
of them). Is there a way I can create a user with SELECT permissions on the
parent without having to individually give the same permission on all
Scott Marlowe scott.marl...@gmail.com writes:
On Wed, Jun 17, 2009 at 3:55 PM, Anj Adufotogra...@gmail.com wrote:
Every time I create new partitions..I have to explicitly grant
permissions on the child tables. I use postgres 8.1.9. Is there a plan to
fix this in a future release.
I believe
How do I do the following:
1) Create a user group.
2) Assign access to select, delete, insert, and update to any table
found in the following X number of schemas.
3) Assign the newly created user group permissions to a new user.
Thanks,
Lance Campbell
Project
I believe that this is dependent on what version of postgres you are
using. What you want to do is create a role. You do this by issuing
the CREATE ROLE command...
CREATE ROLE select_role;
GRANT SELECT on MyTable to select_role;
GRANT select_role TO MyUser;
Carol
On Feb 3, 2009, at
Campbell, Lance wrote:
How do I do the following:
1) Create a user group.
2) Assign access to select, delete, insert, and update to any table
found in the following X number of schemas.
3) Assign the newly created user group permissions to a new user.
When you're going through the tables,
Hello list,
I've been a PostGres user for a while, but am just now having to implement some
security for a project. The hope is that we can create an environment through
Roles that would allow users the ability to create a database(s) and have
access to their database(s) but not have access
Trent Pingenot [EMAIL PROTECTED] writes:
I've been a PostGres user for a while, but am just now having to implement
some security for a project. The hope is that we can create an environment
through Roles that would allow users the ability to create a database(s) and
have access to their
PROTECTED]: RE: [ADMIN] permissions on tables
Subject: [ADMIN] permissions on tablesDate: Mon, 17 Mar 2008 16:26:27
-0400From: [EMAIL PROTECTED]: pgsql-admin@postgresql.org
Forgive me if this is not the correct list for this type of question.
I thought I understood PostgreSQL’s privileges
Subject: [ADMIN] permissions on tablesDate: Mon, 17 Mar 2008 16:26:27
-0400From: [EMAIL PROTECTED]: pgsql-admin@postgresql.org
Forgive me if this is not the correct list for this type of question.
I thought I understood PostgreSQL’s privileges well enough, but I’m running
into problems
_
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 4:33 AM
To: Hyatt, Gordon; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] permissions on tables
_
Subject: [ADMIN] permissions on tables
Date: Mon, 17 Mar 2008 16:26:27 -0400
From: [EMAIL PROTECTED]
To: pgsql
Subject: Re: [ADMIN] permissions on tablesDate: Tue, 18 Mar 2008 08:30:31
-0400From: [EMAIL PROTECTED]: pgsql-admin@postgresql.org
Thanks for your response.
I did not explicitly use NOINHERIT (in fact I used the PgAdmin v1.6.3 New Login
Role and new Group Role wizard to create
Forgive me if this is not the correct list for this type of question.
I thought I understood PostgreSQL's privileges well enough, but I'm
running into problems, so I must misunderstand something.
I have a website that I'm adding functionality to, and therefore need to
expand the
Kevin Kempter wrote:
Hi List;
we have some monitoring/alert scripts which run sql against the database
(8.1.4) as a non-superuser. The problem is I get insufficient privilege
when trying to access current_query from pg_stat_activity.
I ran these grant statements but still no joy:
grant
Hi List;
we have some monitoring/alert scripts which run sql against the database
(8.1.4) as a non-superuser. The problem is I get insufficient privilege
when trying to access current_query from pg_stat_activity.
I ran these grant statements but still no joy:
grant select on pg_stat_activity
Tom Lane wrote:
Milen Dzhumerov [EMAIL PROTECTED] writes:
I've been trying to figure a few things lately but I could not so I'm
asking on the list. I need to programmatically (through JDBC):
1. Figure out if the currently logged in user can create a schema
2. Figure out if a role
Hello all,
I've been trying to figure a few things lately but I could not so I'm
asking on the list. I need to programmatically (through JDBC):
1. Figure out if the currently logged in user can create a schema
2. Figure out if a role has USAGE privileges on a schema
3. Figure out if a role
Milen Dzhumerov [EMAIL PROTECTED] writes:
I've been trying to figure a few things lately but I could not so I'm
asking on the list. I need to programmatically (through JDBC):
1. Figure out if the currently logged in user can create a schema
2. Figure out if a role has USAGE privileges on a
Alvaro Herrera [EMAIL PROTECTED] writes:
No, that's why I haven't mentioned it :-) I know I can't do anything
about objects in other databases. But I have wondered if we could
implement CASCADE behavior for an object whose dependencies are only
local to the current database (where CASCADE
Hi,
I'm using PostgreSQL 8.0. I created a group called grpA and granted grpA
'SELECT' permission on view viewA. When I dropped grpA and created group
grpB, group grpB 'automatically' has SELECT permission to viewA. After
dropping a group with permission to a view, I see that the permission
On Fri, May 13, 2005 at 03:43:54PM -0500, Harris, Richard wrote:
Hi,
I'm using PostgreSQL 8.0. I created a group called grpA and granted grpA
'SELECT' permission on view viewA. When I dropped grpA and created group
grpB, group grpB 'automatically' has SELECT permission to viewA. After
Alvaro Herrera [EMAIL PROTECTED] writes:
We are working on it, and hopefully in 8.1 you will be told where the
user/group is referenced if you try to drop it. Automatically deleting
the references from all ACLs has not been discussed but it's a possible
outcome of the implementation.
[
On Fri, May 13, 2005 at 10:48:13PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
We are working on it, and hopefully in 8.1 you will be told where the
user/group is referenced if you try to drop it. Automatically deleting
the references from all ACLs has not been
Hi
I have a problem with permissions. I have a user admin1. His permissions are
select, insert, update and delete on table employee.
After connecting with this user, I tried to create a table, and it worked.
Why does this work? I don't want, that admin1 can create tables.
Before I gave admin1
I hoped to see that and per database allow/deny
ctreation of tables to groups/users in PostgreSQL 7.1
but as far as I know it will not be done.
Rumen
--- [EMAIL PROTECTED] wrote:
I've been searching the lists and found a similar
question but there have no
replies.
What I would like to be
On 1999-11-29, Alexey V. Meledin mentioned:
1. I create a database from my script and must GRANT all
tables, subsequences, indexes (amount 100) to some users I need.!
Yehh... GRANT does not allow me to grant all tables during one query.
If there any function(procedure) to do this for all
Is it normal/desirable for any user to be able to select (haven't tried
insert/update) in the pg_* tables?
Is it possible to GRANT/REVOKE on the pg_* tables? It seems it is. How
can you see the permissions if \z doesn't work on the pg_* tables?
Given a multi-user environment were each user
Jorge Maturana wrote:
Hi all,
How can i grant some privilege to a user on a tuple?
I found only grant and revoke to do this in a class.
Some help?
You could use triggers (in C and TCL currently).
Vadim
31 matches
Mail list logo