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
Hi,
I have the structure on Postgre:
database: dbGlobal
schema1: sch_sist1
2009/10/26 Eduardo Sá dos Reis
> 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 ac
Scott Marlowe writes:
> On Wed, Jun 17, 2009 at 3:55 PM, Anj Adu 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 that strictly speaking, it's not cons
On Wed, Jun 17, 2009 at 3:55 PM, Anj Adu 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 child
> tables ? Every
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,
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 11:33
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 th
tt, Gordon; [EMAIL 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 Po
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 the
Gord
_
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:
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,
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
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
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 o
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 CASCA
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
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 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
> dro
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 t
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
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
21 matches
Mail list logo
