Mailing List Archive


Back to the month index Back to the list index
Jason Armstrong (jason@datrix.co.za)
Wed, 26 Nov 1997 11:12:26 +0200 (SAT) 

Date: Wed, 26 Nov 1997 11:12:26 +0200 (SAT)
From: Jason Armstrong <jason@datrix.co.za>
Subject: Re: What about the permissions?
Message-ID: <Pine.LNX.3.95.971126110800.21027A-100000@shark.datrix.co.za>

On Wed, 26 Nov 1997, Anthony Cuykens wrote:

> I am wondering who may read/access a DB once I created
> it. I do not speak about the access via w3-sql but throught the C
> embeded API. Is it a way to deny the access right to an user?

You need to have the file msql.acl setup. There is included a
msql.acl.sample file which you can edit and then rename to msql.acl.
Here is also a snippet from an earlier posting to this list:
____________________________________________________________
The ACL file contains a list of the databases and users that can access
these databases. Just for example, if you have a database called
"MyDatabase" and wanted to restrict it to the userids: fred and wilma, the
ACL would look like:

database=MyDatabase -> Database Name
read=fred,wilma -> Userid's allowed to read the database
write=fred -> Userid's allowed to write to the database
host=* -> Hosts allowed to access the database
access=local,remote
option=rfc931

  Then just shutdown the mSQL server and reload with the msql.acl file
  in the mSQL root directory.
_____________________________________________________________

        Jason Armstrong
        jason@datrix.co.za