"Alexander James Spence [axs]" wrote:
> If I wanted to set this as a default for all new databases and
> users how/where do I alter/create a schema other than public?
You could do the REVOKEs against the template1 database (or whatever
database you use for creating these if you don't take the
admin@postgresql.org'
Subject: Re: [ADMIN] Privileges question
"Alexander James Spence [axs]" wrote:
> will have to create around 200+ users and user databases for
> student project use. I have tried all sorts of GRANT and REVOKE
> combinations but for the life of me cannot stop other
"Alexander James Spence [axs]" wrote:
> will have to create around 200+ users and user databases for
> student project use. I have tried all sorts of GRANT and REVOKE
> combinations but for the life of me cannot stop other users from
> creating tables in a database that is not their own.
test
Hi All,
I will have to create around 200+ users and user databases for student project
use. I have tried all sorts of GRANT and REVOKE combinations but for the life
of me cannot stop other users from creating tables in a database that is not
their own.
EXAMPLE:
Create userone with a database
FM <[EMAIL PROTECTED]> writes:
> BUT if I grant the same priv to the group (that include the user) :
> SELECT nextval('reflex_cited_reports_id');
> ERROR: permission denied for sequence reflex_cited_reports_id
Works for me ...
regression=# create sequence s1;
CREATE SEQUENCE
regression=# create
Hello,
We are using PGSQL 8.3.4
I have problem to grant privileges to a sequence.
If I grant all to the user I can do something like :
SELECT nextval('reflex_cited_reports_id');
SELECT nextval('reflex_cited_reports_id');
nextval
--
40442939
(1 row)
BUT if I grant the same priv to the
Could it be the search path (schema) issue? Just a quick thought...
Regards,
Ben Kim
On Thu, 28 Aug 2008, Carol Walter wrote:
Hello,
I asked this question yesterday, but perhaps I did so in an unintelligible
way. I didn't get any answer that time. Someone usually answers my
questions, s
The problem is solved. It wasn't until I tried to work with the
database in PhpPgAdmin that I got an error message that pointed me to
the solution. I had not granted privileges to the schemas. I had
never had to grant privs to a schema before and the documentation
seemed to indicate that
On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
>
>> I granted the app_admin role to my user name. When I try to
>> describe the table using the "\d" psql command, it tells me there are no
>> r
On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
> I granted the app_admin role to my user name. When I try to
> describe the table using the "\d" psql command, it tells me there are no
> relations.
I believe that this link explains the problem you are seeing:
http://www
Hello,
I asked this question yesterday, but perhaps I did so in an
unintelligible way. I didn't get any answer that time. Someone
usually answers my questions, so I must not have asked it very well.
I have a new database that I'm building for a faculty research
project. I created a ro
Carol Walter написа:
Hello,
I've had trouble several times when granting permissions on tables when
I had not also granted permission to the sequence. The sequences may
only have select, insert, and usage privileges. I can guess that when I
grant select privileges on a table, I need to gran
Hello,
I've had trouble several times when granting permissions on tables
when I had not also granted permission to the sequence. The
sequences may only have select, insert, and usage privileges. I can
guess that when I grant select privileges on a table, I need to grant
select privileg
Carol Walter <[EMAIL PROTECTED]> writes:
> How do you make a user that can only create temporary tables?
Well, you grant them TEMP privilege on the database, and you revoke
everything else. I suspect the key bit you're missing is to revoke
public CREATE privilege on the "public" schema.
Hello,
I'm running PostgreSQL 8.2.3 on Solaris 10.
I'm still trying to give my users the access they want without
"giving away the store". They want to be able to create temporary
tables in a specified database. I created a test role and a test
database. The database has two tables. I
On Thu, Jan 20, 2005 at 10:33:00AM +0100, Düster Horst wrote:
> I work with PostGIS. To update PostGIS you need to replace different
> functions, operators etc. for it it exists an update process which
> expect the use of a TOC list. I think the best way is to patch this
> pg_restore bug
I'm sure
Fuhr [mailto:[EMAIL PROTECTED]
Gesendet am: Donnerstag, 20. Januar 2005 09:02
An: Düster Horst
Cc: 'pgsql-admin@postgresql.org'
Betreff: Re: [ADMIN] Privileges where not restored
On Thu, Jan 20, 2005 at 08:47:13AM +0100, Düster Horst wrote:
> >Are you sure reordering was necessary?
On Thu, Jan 20, 2005 at 08:47:13AM +0100, Düster Horst wrote:
> >Are you sure reordering was necessary? Did you try to restore
> >without reordering the objects?
>
> Yes I tried the restore without reordering, but it doesn't work due to the
> fact that pg_restore tries to restore some objects of
L PROTECTED]
Gesendet am: Donnerstag, 20. Januar 2005 05:07
An: Düster Horst
Cc: 'pgsql-admin@postgresql.org'
Betreff: Re: [ADMIN] Privileges where not restored
On Wed, Jan 19, 2005 at 05:33:37PM +0100, Düster Horst wrote:
> I want to migrate a DB from PG 7.4.6 to PG 8.0.0. Thus I dumped
On Wed, Jan 19, 2005 at 05:33:37PM +0100, Düster Horst wrote:
> I want to migrate a DB from PG 7.4.6 to PG 8.0.0. Thus I dumped a PG 7.4.6
> DB with the command
>
> pg_dump -Fc -h host -U user dbname > db.dmp (pg_dump Version (PostgreSQL)
> 8.0.0)
>
> after the dump I create a TOC list file wi
I want to migrate a DB from PG 7.4.6 to PG 8.0.0. Thus I dumped a PG 7.4.6
DB with the command
pg_dump -Fc -h host -U user dbname > db.dmp (pg_dump Version (PostgreSQL)
8.0.0)
after the dump I create a TOC list file with
pg_restore -l db.dmp > db.lst (pg_restore Version
(Postgr
Hello,
how to show all the privileges of an user or group?
does there exist information on how to set privileges?
Best regards,
Cwhisperer
--
Download the UD Agent and truly be a part of a
world-changing project. The National Foundation
for
22 matches
Mail list logo
