I have three table:
Users - Contains username, ID etc...
Permissions - A permission name and ID
Link up table - The user.id and permission.id
If a user.id and a permission.id row exists in the linkuptable the user
have that permission granted.
With the statement below I can see the permissions
Richard Huxton wrote:
L van der Walt wrote:
The big problem is that the administrators works for the client and
not for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators
do require root access.
About th
on to protect the data.
Richard Huxton wrote:
Don't forget to CC: the list!
L van der Walt wrote:
Example: On a MS Windows Server with MS SQL Server. The
administrator with the administrator username and password can not
access the SQL server data. He also needs the SA username and
pa
Berend Tober wrote:
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do anything.
3. Disable all tools like pg_dump
How do I sec
.
How do I secure a system in the same way with Linux and PostgreSQL.
Richard Huxton wrote:
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
Prevent anyone from logging
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do anything.
3. Disable all tools like pg_dump
How do I secure a database if I don't trust the administrators.
The a
