On Sun, 16 May 2004, Gregory S. Williamson wrote:
> In postgres 7.4, is there any way to stop a user from creating tables in a given
> database ?
Make the user not have rights to create objects in any schemas. Most
likely you'd only need to change the public schema, but if you've granted
create
On Thursday 13 May 2004 09:36, Raul Secan wrote:
> I just want to install the latest PostgeSQL database server (7.4.2). I am
> running a Red Hat Fedora Core 1 OS, and I just found a link
> (ftp://ftp10.us.postgresql.org/pub/postgresql/binary/v7.4.2/fedora/fedora-c
>ore-1/) where I can download the
Oleg Bartunov wrote:
On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote:
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
quite peacefully, no problem
Thank You,
thats a releif to know.
Hi !
I administrate a development server for a little team, and people want
to be able to grant access to an entire database to other
developers/freelancers.
Up till now, I see two possibilities :
1. Write a script that queries the postgres internal tables for all
tables,schemas,sequences,views,fun
Hi,
I would like to know if PostgreSQL (7.2.4) supports any
scripts/utilities to check for data/index consistency of a database.
This could be useful in case of the server crash or some data on the
disk getting corrupted. Informix provides the tools 'oncheck' and
'archecker' to perform data-/index
perhaps you misunderstood my question. I downloaded a binary package
off the Debian website. How do I determine what options it was
compiled with? That is my question.
Jared
[EMAIL PROTECTED] (Peter Eisentraut) wrote in message news:<[EMAIL PROTECTED]>...
> Jared Evans wrote:
> > How would I d
Hi !
I administrate a development server for a little team, and people want
to be able to grant access to an entire database to other
developers/freelancers.
Up till now, I see two possibilities :
1. Write a script that queries the postgres internal tables for all
tables,schemas,sequences,views
Ulrich Meis wrote:
> 1. Write a script that queries the postgres internal tables for all
> tables,schemas,sequences,views,functions,... and then executes grant
> statements for each one of them. This would have to repeated each
> time a new object is created.
Yes, that's the most popular method so
Hi,All,
How to config log file to log statement without CONTEXT stuff? I want
log query, but not the detail unless there is a problem,
e.g. Delete aaa from mytable where mysqlfunction(bbb);
I want log this statement,
but not any CONTEXT inside mysqlfunction, because it will easily filled
up my
Stephan,
Thanks for the info, but alas, no success.
I have:
List of database users
User name | User ID | Attributes
---+-+
testuser | 100 |
postgres | 1 | superuser, create database
And as postgres I ran:
REVOKE AL
On Mon, 17 May 2004, Gregory S. Williamson wrote:
> Stephan,
>
> Thanks for the info, but alas, no success.
>
> I have:
> List of database users
> User name | User ID | Attributes
> ---+-+
> testuser | 100 |
> postgres |
Of course ... implicit in the docs if I reread them.
Thanks very much for the tip ...
G
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 1:45 PM
To: Gregory S. Williamson
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Keep a user from creating tables
Title: Hardware Platform
I'm working on a project using PostgreSQL as our database designing a budget system. We are still in the design and testing phases but I thought I would ask advice about a platform to host this system.
We aren't a large system, probably no more than 50-75 users at an
Jie Liang wrote:
Hi,All,
How to config log file to log statement without CONTEXT stuff? I want
log query, but not the detail unless there is a problem,
e.g. Delete aaa from mytable where mysqlfunction(bbb);
I want log this statement,
but not any CONTEXT inside mysqlfunction, because it will easi
14 matches
Mail list logo