Re: create a limited user in Postgre - Mailing list pgsql-general

From Sim Zacks
Subject Re: create a limited user in Postgre
Date
Msg-id fn412m$681$1@news.hub.org
Whole thread Raw
Responses Re: create a limited user in Postgre
List pgsql-general
That's not very open-source of you. LOL.

Aside from database permission issues, which are not a problem, you would also
have to not give them superuser access to their own database server (something
that a lot of companies will not be happy with). Especially if they want to the
possibility of other databases on the server. You would also have to prevent
them from holding onto the backups, something that most companies would not
tolerate at all.

sim



Guillermo Arias wrote:
> Hi, i have a question:
>
> I have a database and i want to create a administrator user with total
> control and another that only could make queries and could not see nor
> modify the functions.
>
> The reason is that in the database that i will distribute are the
> functions with a big part of the software logics and i do not want
> these to be seen by my customers.
>
> Thanks in advance, Guillermo

pgsql-general by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: publicar
Next
From: Julio Cesar Sánchez González
Date:
Subject: Re: postgresql source build instructions for ubuntu 7.04