View Issue Details

IDProjectCategoryView StatusLast Update
0006975VALENTINA SERVERFeaturepublic2014-12-08 14:54
ReporterIvan SmahinAssigned ToIvan Smahin 
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version 
Target Version6.0Fixed in Version6.0 
Summary0006975: Access Control List (ACL) for registered databases.
DescriptionIt looks like vServer's ACL (see http://www.valentina-db.com/bt/view.php?id=5486) but could be defined for particular database under this vServer.

To get that ACL rules:
SHOW DATABASE PROPERTIES;
or
GET ACL PROPERTY OF DATABASE;

To set ACL rules (available for admins only):
SET ACL PROPERTY OF DATABASE TO '<rules>';

where <rules> is a list of specific IPs or subnets prepended by '-' or '+' sign. Plus means allow, minus means deny db access. If subnet mask is omitted, like "-1.2.3.4", then it means single IP address.
Mask may vary from 0 to 32 inclusive. On each access request (like db open), full list is traversed, and last match wins.
Default setting is to allow all (empty list).

For example, to allow only 192.168/16 subnet to access the database:
SET ACL PROPERTY OF DATABASE TO '-0.0.0.0/0,+192.168.0.0/16';
TagsNo tags attached.

Relationships

related to 0005486 resolvedIvan Smahin [NEW] Access Control List to allow/disable connections from specific IPs. 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-12-08 14:45 Ivan Smahin New Issue
2014-12-08 14:45 Ivan Smahin Status new => assigned
2014-12-08 14:45 Ivan Smahin Assigned To => Ivan Smahin
2014-12-08 14:50 Ivan Smahin Status assigned => resolved
2014-12-08 14:50 Ivan Smahin Fixed in Version => 6.0
2014-12-08 14:50 Ivan Smahin Resolution open => fixed
2014-12-08 14:53 Ivan Smahin Description Updated View Revisions
2014-12-08 14:54 Ivan Smahin Relationship added related to 0005486